v08.02.0100 uploaded

Hi,

I've uploaded builds of v08.02.0100 to
ftp://ftp.postgresql.org/pub/odbc/versions. It will appear on the
mirrors and the main downloads site at
http://www.postgresql.org/ftp/odbc/versions/ in the next 24 hours or so.


This is intended as an official, stable release. Please report any
problems to the mailing list.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: v08.02.0100 uploaded

Dave Page schreef:
> Hi,
>
> I've uploaded builds of v08.02.0100 to
> ftp://ftp.postgresql.org/pub/odbc/versions. It will appear on the
> mirrors and the main downloads site at
> http://www.postgresql.org/ftp/odbc/versions/ in the next 24 hours or so.
>
>
> This is intended as an official, stable release. Please report any
> problems to the mailing list.
>
> Regards, Dave.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

Hi,

I have downloaded the MSI from the ftp directory mentioned above. I have
done as the readme file states, and that is to uninstall the previous
development snapshot (removed registiry entry's, and deleted files).

When I try to install the new version I get an error of a certain file
that cannot be found in the cabinet file. (See attached image)

Is this something I should be looking into on my own machine, or is
indeed something wrong with the installer? Changes are I'm one of the
first installing this ;-)

Some info:
- I have downloaded and extracted the zip file with the MSI several
times, thinking the zip file could be currupt, but the problem remains
- I'm Running XP Pro with SP2 and all the latest updates.
- ask if more info is needed.

Regards,

Stijn.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: v08.02.0100 uploaded

=20

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org=20
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Stijn Vanroye
> Sent: 31 August 2006 13:11
> To: Dave Page; pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] v08.02.0100 uploaded
>=20
>=20
> Hi,
>=20
> I have downloaded the MSI from the ftp directory mentioned=20
> above. I have=20
> done as the readme file states, and that is to uninstall the previous=20
> development snapshot (removed registiry entry's, and deleted files).
>=20
> When I try to install the new version I get an error of a=20
> certain file=20
> that cannot be found in the cabinet file. (See attached image)
>=20
> Is this something I should be looking into on my own machine, or is=20
> indeed something wrong with the installer? Changes are I'm one of the=20
> first installing this ;-)

Well, I've tested it on my day-to-day XP SP2 workstation, and a clean
Windows 2000 Pro VM that I keep for testing, and both were fine. If
there were some weird dependency I'd expect it to show up on the Win2K
machine.

What's the file it's looking for? Your attachment is missing...

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: v08.02.0100 uploaded

--20422718-30230-1157028687-704
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

> > Hi,
> >=20
> > I have downloaded the MSI from the ftp directory mentioned above. I=20
> > have done as the readme file states, and that is to uninstall the=20
> > previous development snapshot (removed registiry entry's,=20
> and deleted=20
> > files).
> >=20
> > When I try to install the new version I get an error of a=20
> certain file=20
> > that cannot be found in the cabinet file. (See attached image)
> >=20
> > Is this something I should be looking into on my own machine, or is=20
> > indeed something wrong with the installer? Changes are I'm=20
> one of the=20
> > first installing this ;-)
>=20
> Well, I've tested it on my day-to-day XP SP2 workstation, and=20
> a clean Windows 2000 Pro VM that I keep for testing, and both=20
> were fine. If there were some weird dependency I'd expect it=20
> to show up on the Win2K machine.

I figured that you would have tested it, but still I find the error pretty =
ackward.
I forgot I have some VM's here myself I can use for testing. There it insta=
lled flawlesly. I guess it's a problem on my machine then. My guess that th=
e previous version isn't correctly uninstalled. What I have done is removed=
the registry entry's referring to PostgreSQL in [HKEY_LOCAL_MACHINE\SOFTWA=
RE\ODBC\ODBCINST.INI], as well as removing the installed files (dll's and s=
uch.)=20
If I run the installer on my day2day machine I don't the usual screens with=
the license agreement, and which parts I want to install, it just starts c=
opying files immediatly. On my VM asked some questions first.
Any Idea what I missed when uninstalling the dev. Snapshot on my day2day ma=
chine?

I'm sorry I might have spooked you with this. Maybe an uninstaller is a goo=
d option for future releases?

=20
> What's the file it's looking for? Your attachment is missing...

Oops, my bad. I guess I forgot the attachment. I've attached it to this mai=
l.



=20
Regards, Stijn.
=20=

--20422718-30230-1157028687-704
Content-Type: image/png; name="psqlODBC.png"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="psqlODBC.png"

iVBORw0KGgoAAAANSUhEUgAAAXMAAAClCAYAAACuqh0UAAAAAXNSR0IArs4c
6QAAAARnQU1BAACxjwv8YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUw
AADqYAAAOpgAABdwnLpRPAAAABh0RVh0U29mdHdhcmUAUGFpbnQuTkVUIHYy
LjcwnFTlcQAARtlJREFUeF7tnQecVcX1x58mUf+J+f9NFEsiiiUqiigYCwiC
CCxFYJGiiBgFNZpujEkUTWKXYgNLVCRRafYugooFBKSKFGHpvS19lw7n/ztz
79w399657e17y9u3s5/P+ex7990yd+bMd849c+bcg0pLSymFv8MOO4z/ib/D
Dz/c+Ww+mBowNWBqwNRAftVAWVmZv0AMcxb8yFAXcuNNN9G9991HDzzwQFoe
fJAe8MiD+O6Shx6iBxV5CJ998vDD9JAiD+OzW/rgu0f64Lsiffr0JZf0xXeP
9O3bj1zSrz/19cgjjz5Kjz72mCOP4bNPHn+cHtPI49jmkyeeoMcTyhMDBlC2
ZMDAgRQkuntIuo3PPfDJJ4Wo1+Hyq/WY6WdxTpzLK1xO2VZ87SefesovvD1A
ZJl9//l+NMLl4Gv269/fJV79cb57dU357tVL57tXh5Xvqq5rP3v7R+B3q2/1
Qd9h6Ys+0q9fPyH9cW8sjzzyCD3K/QAidV/V6yegz7o2CdrG+7PIc6j9ia/B
12Pha8uy8HZuu4EDLRkwgPVAEY1ey31d/23dlO3s1gfozJOKKDr0FD478vTT
9JQtT+O/I888Q0975Jl//5t08u9nnyWvPPvscyTkubQ899zzJOR5S55/flBa
BuGzkBccGfTCC+L43nfd7bCauS0lJWEuIf7n226jbld3p0sva04XNmxIFzRo
IIQ/e+WihheTKg0ubkSqNGzUmHzS+BJqqMjF+KxKo0uakF+aYltaGje5lFS5
pGkz8kqTS5uRS5pdRk080qxFS2rRqrUjLfHZK0Wt25BOWrVpS15p3fZy0srl
2B4k7dpR6xBp0649xZW27TtQkBShvC1xLxWR1pe3o3bFHYVc3qHYEb6mWo9B
n5u3akVhwnXUtn17n/D25kVF1LxlEV2Oa3XoeIVP2qNMQdIOZdUJn0snfD98
r5c2b0FN0Q+kePXH+e7VNeW7Tjd5m1eH1e+qrus/6/pI8LbGTZriek3RRy4V
faIp+gFLM9zfZegDLFy3rPtFLNAT1m3W5TaoB5a20EOWoDrj7XIf3l/2Az6P
OCf3syK0P67D1+Nry3Jchs+Xo907sG7hPFIu5+sJQTt5pT30zyPtOuB4RVz6
AJ1pr0iHKzqRlGJ8/kXt2jT9m2/o3ffey0uZ+PXXVLNWLXoOgP/7HXdSfwyA
d/3jHwLqLpjzhqu6daOevXpR46ZNHYBLkBcqzLmzVheYt0LHrAjI+VgeEHQw
Z7Dzb1FAj4J5Udu2Wpgz4CXMGRSVAXMG+mUAT1WGORtJbBipMGegqzCXQGfI
Mmx9MLeBnhTmbWzDRsCcdccDcwY6G4yyLLyfF+YM9cqC+alnnEHjJ0ygl4cM
yUsZ89lnAua/++Mfqfu1v6Lrb7iR/vmve+i2v9zuAF1Y5gzzq7t3R6M30YK8
kGHeHAosIVTIljlDsKIw5+MZ3F7LnLfxYFFRmLdo3ToQ5i3xGwNHdPpKsMzl
00YhwdxrnTNMvTCX1rl86mQoq9Z5XMtchbm0zlXL3Gudc9sKS5r1y2ed594y
P+W00+jTMWNoIFwuSeX3f7qDOnW9yRH+zucI2p70/Lz/e++/L2D+9zvvFDBn
ua7XjXRH77vSMGeQX9ayJSqyOBDkhQpz7qhsfVUHmDOcsuFqYZePDua8vaIw
Z8td52bhba1gtUvrkTu8F+jZdrPI+ioEmHut8yBXC8M2ytUSBvNQVwu7+DSu
FmmdN2veXLhpDhTMTzr1VHrvgw/oPswDJhUGufrH32+65c8C7t7tSc8t9x8+
YoSA+T/uuceBOQP9T3CL97rxRulDT1HnblcKX5rqVvF+LkSfOXdU1W9eyJY5
wykbrhY+hw7mbJ2z5R4G9Cg3SxjM22BegWHOwp2+MmDOA5TqN69qPnM5FxXm
atFZ59LH7fjNc+Rq4acC1dXSOtDVknvLvNYpp9CIV1+l226/PbFc1/O3Atz7
9u1zRPed98vk/HzM85j8ZJjfj6ASaZnz/xtu+jXdeZdlnXN4C3Xp3g0gT092
6qBeqDBX/eaFDnOe1MuGqyUI5lF+8zgwD5oEZetcPqbz5FplwJwHQHbDVdUJ
UBXmXqBLX3WUq0VMgiZwtUjrXLpmvBOhsg11E6G8jf3mfuu8cmDe++676Yw6
dTKSS1u0F0DfvXu3T3g7/57pufm4m265RcD8IUQlqTC/5rrrqbc9ESpg3vnq
q+j8i6yolSApVJhzR60ubha2NLPhagmCOQ8WFbXMi9q0CXS18ESajLqoLJhz
fRUizHWuFvnkEzURGsfVImHumgi1o8W8US2qq0XvN89/mDNwJdDXrl1LUrIB
8jCYd//VdW6Yd8oRzC9BOJQMgeJHKiEclsQhgTzxaIsMj7JCpFrCt8a+u7RI
JZP/i1rx7LglLVq2QqhTER7X+JGNQ60QYlXU2gkbZGubj+Nreh+TZSetLjDP
lt+8HeZX1NBE+TkqRDGOZc4TnUF+89aK37yyYK6GKFZlN0uY3zyJdZ7tqBbV
1cLlEKGnvhBFA3NpmT+IdQOqZe6D+RU5gjmDvAVAyp3wcvg8LbFiRzt07Cik
GJKOJ8XkmjKTHfhZiRtm5WrTth21ao24bwh/5vO1w2O5iOCIAXMZ0VLobpZs
+c35PDqYR/nN48CcQxDZP64DOrenHNDZglOBnosJUL5PfpphQ4AH/qoKcxmi
GORqUWPO5SSzGtUiXSVx482DXC0yRFFOhEojTsacM8yFC83naoHxkOM4c/aZ
Z8PNsmzZMvJKNqxzCXOvz9wH844KzBs2bkyNEKLY5NJLYUlz6JIlTZvxYoO0
NGvBVjCsYQDbETRGc7aubWGIc8N07j+KFi9eTKMeuZK6Xnklde5yG708ZbHY
JmTKy3Q7tl/JcvsQmiK3O78PsX+/Sv/7qP7UEYH/Um59aUr63DjH5MG3hFrm
chK0OsA8GyGKbK0GwTwsRDEuzFlvtNY5wMpPbLrFQ7mCuRqiWGgwD1tAJF0t
MkRR9Z3Htc6TuloY5nxdv6slv2Eu3SsLFiwgKQxw7/eK+M0lzO/DqvxQy7xY
gTmDnOFdhMfddh2wGsuWNliF55VWHG7E4UwQ/tyWF3TgEVxK5y5dqBsWI/V4
4mMB148HXEfXXTeARguAD6W/drsav/+Vhk3F96nDqfd1+L33cJqK36cMuR1w
t+DN372/Tx1+J1177bX016FTce6pNOT2bnTlVd3okVE8QEyhl27tFNsyl5Og
1QLmWfCbsx85COZhIYpxYR7oN+ey235z7+KhXMJc+s0LGeYMUnU1qBOmqK4G
zVFUi4w5t9w9cLXwk7vL1ZLfMGdwf/fdd45IS1y3PdNJUAnze5BmJRTmHbqn
J0DZImeQF9/6krCQp0xRrNxRj1CXrl0hf3FZ1iP7FlNHLOS49WW57ygaMoQ/
T6URd/WkXgM/ETD/ZGAvunvENHyeRsPvvFbAmKXngPTvve4eQdOw79Rhf6dr
rrlGyF3iGOt4+fu0EXdTL6xYHfAxw/sTGsADwQBr0Bj1WHfq1LlzIpizq6U6
wDzXrpYwv3lcmLcIijdHJ2cLUbd4KJcw5wGqqrtZvK4WXgmqrgbNtqtFXdov
l/erq0Gl+1N1tTDMWXjAdrtaeCGRB+hZXs5fETeLtMzlwiFpgQdtTwr0BvCW
XAHDWBdn7nOzqDDnkZGtcdUivqNHD/rrMLaAF9PoJ3rQHcMta3jY37qLNAAs
3R8bLX5ni7lHjycs6xvQHnE3AKzAfOAnFnwfvRpWuS0977IALgANmDuW+VWw
zCHe33lfx0UjIQ+wWwOFZaWzv519cU5+Fk1uFnVBCC8eqi4wz0aIYpirJShE
MS7MA/3mdn4Q3eKhXMKcB6hCg3mcXC3aqJYMc7XEiWqRk6HspuVcOmnrPL9h
nhTOSfZnkLfHvGKDRsh7Bbn7n/8Mt8zbX9PNCU3kjnRFp07C3eEAFqBMA/Uu
x5IW1vKAntSzZ0/H4hbwdsCaHZi7ymJb7tNGoBy4rrTG2Wq3BoppAuasCHL0
j4pmkYuHqgvM2dKsaLx5mKslKEQxCcx5xafPb27DXLarungo1zDXRUPle6It
bxI7Xa6WOH5zV+KtTF0tdvKtsFwtMl8LG5TCjeZMhFowd1nnWbbMO8HyZVdG
PsmNN98sLHKG+Iknn0xXw0sRGc3SvkdCmAOiPXsOoE+khfzJgNgwT+pmYev9
TvEkYA8MDswtN4sL9PYTwOjHewh3EPvuWSlYgdiNEhSayDBnv3l1gTlbmhWF
OYdzBvnNg1wtSWCuDVG0YS7aU0RJpRcP5RrmOv2pqjCPu4BIzaRY4VwtCsyD
crVImLOrhftiZcKcXRj5KAxxhjmD/I7evene+++PsMxDYL744wFwm/Sg24da
PvAhf7XcKpyYy3GnjH4Ck5zSzdIboL+LRkzzu1kymQDtcpsd3TL6ceqOG7r2
TmuClH3q/N2aAMXk6hPsf5funVHUDyOagPnvX6QP//vbSJiLxUMav3mhpMD1
psat6OIhhjlb+EFA1y0eSgJzravFhrkMUeQOL0MUcw1zrq+qPAEathr0QKXF
9eZqUWFupcWVMee5t8yfQM70ypbHkbv/MeR+fxS58zmlbR/keH8YOefZ+uac
LAzuf957r0h1y9t8IOeEW95FQ+2uvTrQzaL6pqe8dCuW2nagP7hC/0bRI10R
cgjpJyJJLJk2zZro5AnQa+1olnRoYn8apfq9o0ITP+oH109nIQ7cleM58qUL
rm/J7fSSGvbIoYkxYS4tEdVCNzDX50BnWHMYYi5h7lvab8Oc3SvSby58q5yn
Osv5zL2DH7uOAv3meZrPXOdmiUqLG5irJQdRLV6YC3eona9FjTmXLhaXqyXL
bhbOac7SEYyRckXnLiSlU5eu5Aie+juxIJRaSmdE3knpgqg6lq6KXInIPa9c
hfdGsHTrfo0tPfDflmuupW6Qq3v8yhFXFIudOdEH8/a/6h4I86nD/iZ86K0Q
4cLSAj51Fv7cll8m4JJ2Io68ByJUVHcKb8t00RCHO6ovgeDv6osGRMJ8RTiv
g8iqZ4dIxnWziAyKmHgp1JdTeOFU0aRbDHOZElcHdB4EvdZ5UsvcF6LogTl3
fhmimGuYy8VDWuu8CsM8LC0u9wc1k6I38ZZcRBR7eb+S49zrapGLwVTrPB1z
zi+t8FjnBuaWu8Vrmbe//hoH5t5oFrbGeRFH3EVDDNtOGNH+JqJfptLLt3UR
IM90OT8v72+GZfpSuNF1y/l5Gb+zlJ9Xg9pvAoqzAlRGtXAZva6WQrXMK7p4
SII6aDWobvFQUpj7QhQVmMvFQzK/ea5hLpNuFQrM46bF9b60Ql0NmgTmYqU2
R8KoL63w5GpRk2+JuHf0RystroE5W+ixLPMO11/rwNwbZz75P78Rq0HjJtoS
j0cAqbUKcwr957dtBcid18fl0Wvj1NBEMQmq8ZsXLMwruHhIwjwoRFG3eCgp
zH1+cwXmcvGQsN74aSzHbhaR1wZPG4UA84xdLexak6+TyzSqxQNz9Q1EXphL
lnQovsJY5nFhXtwrDXN1BSgvHmJLnbfFhTlPpnCcKAOdLXrOzcILEqoKzL2u
lkKFeUUXD0mYB4UoyogZ1dWSCcxdIYoKzNU8LcJ6qwSYi6RbuhwtVczNEpWr
JU7iLe/7QWO7WpT3g3pztajZFOUCIistLuZEvNa5cbPo3SzFN1znWOZqbha2
yBnkvC0uzPnVcwx0qRAMcs6eWFVgzk8R1WECVL60ONMQRSfTpP0qOa3f3PNe
0Exg7gpRVGAuJ0FliGJlwJyfNnhxmc86LxCYx4k5z2WuFl1qXDYm2xuYi0nQ
WG4WFebVMZ+5dLfIAUj1mxeyZV6RxUOqxR0U0eJdPJQJzF1+cw/M5XwIt1Fl
wZzvuxBhzhOhKswDrfMcRLVIV4v3HaHSOr8cVrjP1WIsc71l3vHG64VlLuXi
xk2wiKalWIF3Ld5kceufbxPLSKPkH//8F6nCb4/2Cd5h988Q+dc995Jf7sO2
tNxz733kkvvup3s8ci++u+T+BxCn6RbOQKaTB/Bqpoce7mMJ3uyhk4f79CWv
9EGMaGLp14/6hEp//B5P+iJONak8hPsIusew7Q+ibqT07f8IrquT/s4+vO8D
iJWNFNQ9178qzj2hHvoqwvXP+z340MPU/5FHA6UfyqaTpHXF7cD15dUjn64p
uufVS+e7V4eV76qu6z/r+oh/W1g/499kP3P6EpI43Yc+IuX+Bx6kBx602oLr
WPYJrve0nvdLt0mU/rEe94W+C7H6j9Ax2ddYR2Tb47qyb/L+on37P6q046M+
nesnfk+LSycQx82x3Gl5DJ8teUSRRx97nBxB/DfHgLM89vgTaUFsOMeHP8Zx
4rZwzHhaBuIz4tYVGTDwSfLJk9gGGfgkXiIt5Gm3PIXvED7XA6ibv2HR0J/+
cjv95vd/oBuwOvTaXjf4o1mKbZjHtcovangx6aTBxcgfoIjjWmnUuMq4WWT2
OOlqKWTLvCJ+c9UyD1s8pL4XNBPL3DUJ6rHMVb85h6sGWedqKKv6OcjP6w3j
lN/5PvmavFrYZZ1XQTdLkN/ca517MymK94Nm2zq3o1qCXvisDVGED50tdlXa
sV9dEZc+8FoERTogplyKjDHPqzhzjje3Y8298ebS5SL+e0MT2SI/vXZtKisr
M2LqwOiA0QGjA1VEB9jFyUB3XuhsYG4GMTOQGx0wOlD1dIADNgzMq8jIazpY
1etgps1Mm1WWDhiYG5Cbx2ijA0YHCkAHDMwLoBEra+Q31zFWptGB/NUBA3MD
c2OVGR0wOlAAOmBgXgCNaKyl/LWWTNuYtqksHTAwNzA3VpnRAaMDBaADBuYF
0IiVNfKb6xgr0+hA/uqAD+YXNmhAZ5x5phmpDeSNDhgdMDpQhXTAD/OGDQHz
s0wjVqFGNNZS/lpLpm1M21SWDvhgznlWap+VHzAvL19DO3a8bgYWM7AYHTA6
YHQgQgd8MOfkWGeeVeeAV1z59hm0f/8RRHQo7d17Ga1fv+GAl6myRlhzHWPN
GR0wOpBUB3ww5+yGZ9U5+wCDcxNt25ainTtSgLklkyefSoMGjT3A5TIKllTB
zP5GZ4wOVI4O+GDO6TDPOvsAw3zbdbRuXYr27f4eQF7HAXrHTh2Qb/gTA3Tz
yG10wOiA0QGPDvhg3ghvGalTt+4BrKhVtG51itavTdH+fccA5DcT7f+xAPr4
r2rQT4/sTbNmLcl6+cb0TsnUke7/xcVUXDyYSjLsPPK8vcfYo3PJ4Aqdz1g5
lWPlmHo29VzVdMAH80uaXkpnn3Nu1mEZu2K2/I5WLk3R1g3sXjkWUg9yEu0u
t9wtbdp0pt/+fmgOyzeGeqd60xgJ7wrBVzmXPE+Fzmc6WGw9ynDwNec3OlZV
dcAHc367SN1zDxzM1y5P0doVKdpV9n3A+yeQ/4GcQft3WjD/bPSxdPgRf6cF
C1bmCOhZhLkO3AbmOWo3A6GqCiFT7uzorg/mTZtdRuecW+/AdLhNv6XVi1O0
ZQ2D+39tkPPn4yFHE5Xh8/4UtW7VmW697c0clVEP88GKG8blMklJ90wxDS5R
G4XPI3+Dpa+zzHlb4PHZaWDTUUw9Gh2oHjrggzm/0/DcevVzBMrgSt22bTOt
W3YwrV0CYJfzxOeRtH/H92jsRwfj8w8hpxDtPEhY5++/VZNqHPcvmj9/eQ7K
qYE5gOv3eZfQYPjTHYBHWeE+mMc43rgKctC+1aNjG4BXv3b2wZxf2lrvvPMq
vxNt+jutKklR2SrLKh8+7CeYiDzInow8jJYvA8wB+L2b8fueFDVtehXd0fut
HJQzws2iQtmxqgOscxXwXpi7rPIg6776KaSBkGlzowOZ6YAP5vwG9Prn/TIH
kAwv4NqFKVoHoc2WVZ5KHQL5H/ph6lz8r0fXtKuL7ScQIf6cdqfo3RG16Mij
76EVK9ZmuaxJYK5MlOqs6EiYRxxvLPMst21mncTAxdRbVdABH8xbFLWi8355
fqV2ovINf6NV36VoM7tYhK/8R7ZVfhQdm2qOz5dRcaOzsL2G5TsvxX6A+qVN
utG/7v0wy2WNCfMydpN43C9qFAyDOAzmcY43MM9y2xooVQUomTJmpqc+mLds
1ZrOO79yYb5+3uG0Zm6Kdq+xrHKig+mIH7JlDt946hL8v5R+3+VkbOffTyXi
sEWsDh36/Gl04skPZdk6jwtzrnB1ktM7ARoF8xjHG5gbmBsdMDoQUwd8MC9q
05Z+ef4FlVaB5aUP08pvEcEyH4DeDqvcXiB0dfvDAfFz6ITD2tDPDi6ioY8y
5Nlyh6tlVw3asxKft6YQedOT+j7yUaWV11gNmVkNpt5MvRkdyK0O+GDequ3l
dP6FF1YaHNfN/gGtmYU8LCsRV74HwBY+c0SsvMyTn2fThSfdTI1P70DLpyCq
hXO17Dgcv/+CCKtEaUuK/vNkbap5Yh8s/y+ttDIbpcytUpr6NfVrdCC5Dvhg
3vrydnT+RRdVDhjXwUUyLUUbZgPMG7FkfzuEY8z3peibTzjC42QqbjqAmtdr
LyY9hXsFy/yFdV4O8C/D4iKsFq1f/zoa8OSoyilzzEceo4zJldHUmakzowOZ
64AP5m3btacLL2pQKWBcN6sGrQLMt81D/Hg50t2u+wERhybC4maon37MqXRL
99F0Q3F9/G6DHKtDqYwnSU+g3YvweVOKnupTl06v+xCtXbexUsptFC5zhTN1
Z+rO6EBudMAH83YdiukivG0o1xVevv7ftGISlu5PT9HelYfB/w2rnEHNvnCx
AjRFVzU/Adb5XfTqE4hgYcucQY/l/rSal/qfQPvXHEY72deObaeefiM9+9zH
GZe7ZDASavXu7U6CVQlL79UEX87CJFj/rsRfvceE35cuhj0gOVjQ9UR7j+mN
+vZM5Pri4d2/a88XcgzXc8oXn2+FaCYuW8hTUtJyuSez+anQvs+I+4/qJ1yO
4sElTvt571+/mjid9E38rlmToOpKWBnU66nlCGzvIN2rQBksvbLvSdHl5G0U
pCNqIEJY21llkHUXVDdBfU9X3oz12a5n2SaCP4qeROmV7ncfzNt37EgN8Lah
TE6W5JgNs46g1ZORUEu4WNgqB9DhNhGwZqhj2X7/3jVR+b+haW8egklPezvc
KsSyA4Df9XPahZBGdr083edsqg3rfMuWrRmV3QXzykqKxUruQDcdRSMUxFF6
TwhkWDx7VLkDrifbjZW1Nw9oqlKJThyQeCzofGHHeMvP+/K9ZlK2IJhnVC5P
FJOaaC3TxGs2ANUOm27vdDSTA+yg7Jw+oyKGTsjQWKfsfH/+gdjb3oG6l2kZ
7IgvCVBncMukjQJ1JKTtwupUVzeu+1RWaUfop8O+mPosB+icwrz4ik7UsFGj
jIAYF+bb1z1Lq2CVl06FVb70ULhVkFBrKVwtyMsihGENV8v41w6nQ1NtqXQS
Jj/hThHb+XdeXLQKx3GY4jKAHt+3YVA4q05PGvyfLzIrOxqr92BPetpKsMzT
deZZ3q+AKnLUjmmZe8/D39MWHl+foY2OoXYAL5hF57TgHni+kGO8OjKmtwWY
jMoWa/5CqdewcgW1dYJ7cd+bdd3euD+rwwa3rzguTNd0v8XRTc8+YrCWqZhF
eTTt7alTp10yLYMLgmn3Qia6E3qMDtoJ6tSpGy6v5+mB6yxcP9P3FV+fVd2w
norjPm0FcdZnmXfs1JkaNm6cGRBjda4y2jTzeFrzNQCMkETaAJCvRmZEBjQL
+8EZ2HC37Pzue1TziMus7+x64d/kfgvYOj8O1nlN2o1oGP798X/Vo/Ma9KfN
m7dkVn4tFFHJWBxkPSZ6LFRNkixvXnRuILHNoyC+RyofNKSCBFhh3sdeVuZE
lrl1Xqcc0qLwQie2Za6cL65lrnY2V6ePWbY4+qaWJaxcnvp01UsmlrkNhVAY
quVPAB6rMwdYo646UQcQzfoJoZNhg4yie9ryRZfBbekrvuKg9s5Y39KuKVfb
Bb6LQF83OmiL84Xppy5ddtj+Xt2Io8cx9vHB/IouXakR3jYU18pOul/5midp
zQREsMAy378YYYYbfwpAwypn3zcLQ5qBzVY43C2f/Qe/sx+dv/NvvA//jkVG
wiqn2tjvR7R3jrX9jNo30IsvZfh6OR3MvT42XQcIs+okZF2PdO5l/NLvphuZ
xW8+hfQAXipOFMxd/lC3ZaBa6S6F9g4amkd1a6BTzhdxjNQZ95OB6g+NWbYI
BffVa1i5NJ1P76/WLA7zlUPz9BJlSfvKphgP2mMjLH2Xm0jxI9vbA9vb80To
6F6GZXDcl6E+8/i6kzaWlGNit12QQZZu00CYh/SdZPoc/GSblKXe/X0w79y1
KzVu0iRnMF8/8RBa/VWKdnwD10npUfCRwyqfBxCzINGWgDVb4Lxkn0MROYpl
vW2ZM8zlPrw/+8u3wjrf9wvax9Y5fO6D+9SmM87tk5nvXGuZK28ZklaDtuMF
TJjZIA56jHO7WdTHYOvRzg9yzSN5VLkDoJeenLMGB9fEpBxAfE8MwdaYc75Y
x4RbdbHKFsNasSxPu15jlcuyHl0WtStNQzxr1OcLjQPz2D7zmJa565oq/EPa
W4G9S/cqYpk79xXs60+mO1YbeSeXVaiK+o/9tJOumzCYq/D0XzuePqvnj3Sf
xtLv9NOOBuZX5g7mq56iFZ/BVz4eVvl8pLVdAxeLhDKDma1thjXe//n1CF7O
z5kTD6XTj6tFe3milK1z3p/34/152wIsMtqLRUSLcb6ZKSpHqOPZZ/eip54d
nXxAioKi+rs3D4vz6BuQFtd+tJI+Nd0o7G1oLch1/tWocmuVwgM5V8RMmJ85
yCIMg6b/mHBFjlm2mMoeDOYY8xS+ASDKItaAElZp8eAx7pTJ3rLHBo/deaMG
h4A5DQdyQe1tH+fTPd31YpSB3RPeaB5/1EYy3bH6TvDAEMe1FepO0fjM/fMh
fsMrOBpFljVIN9LRThWxzisV5pumnkSrPsfSffjLafkRcIvATcJAZqua3SQs
DHP4v089jkHO1uJxkPp0R4+TsDrUhjjvx8dJWQsLfyMiW6ZYwL//LxdQvQv6
0saNm5MBXetmSbtE0v4/jyI5Hd4zOvtmwHE/ivXl9icq5xShXGEZFd3Xdyz4
CDeL63rKNXRgDQSgAreg81kz9d75BfV+9HB35hXili0A5oH1GlIu9zFK5Efk
vYTHDIcP0FZIXc6iWQLcD6HtHaR7PnAHw9QNJLVPpI/JRHfC9Dc9J+Vpu6Cn
nTDXjOtJIj1Br9PP9MDidr8F3p/HjVXRcES1rhnm1/zqevmEnaLOXXNkma//
lFZ+irjyLxDBMgORKMsRV85QhjUtYC6FrW5kT0ylvg85kur97Ho64Ud/pLt7
9rDcLnyM3JePZSnBYqPNNeE3P4T2wjLfCp98jeP+QMOHJ4xs0cJccT+4FEOf
ZEv6aR2XhXKM7rFQnTCVDat7ubT1m+edotIPKV86rYW5e4Dxx8r6Q9ac6AoG
ssalFBQPHxYz7ZoP8EQMqKGRst6s/SPKFmKZ6+o1Kl47k2OiLCmdBai6s6Li
zB1L2hObHzfywR8zHV6nvTUvNq9oGSoWZ+62gOOsy3BPXvtf1K7tZwHx797A
Bbd+2gN5bH12D/y5cLO4YX5lbmC+reTXtOyjFK2HZU6zsOhnHmQOJj69wqtB
kXelXcNjAfNj6Jgf9KIx7xJ99EIHayKU3SvqMbPtcyzBZOrsQ6l8orXPVe3b
U9OW/ZNZ5jEf26M6sP73aF9rZufNzWoyUxZTr0YHqpYO+CzzLjmC+bqv69Ci
D1K0cjTcLOMOou2wnssnHETlX9tif94xCXCeYfnG77vlJPrb9V3pvWcaEyGM
cRcWGW2Hi0YcI4+diHMB4DsgW8alaBMsf7bW+//1PDrk/26lyZOz44+qkGKL
R1f3SsAKnS+ng05VUWDvqj9N+GhO6+lAX1+2Uz6UIx/KUFX0NnflbNbC42bJ
Fcy3zv0TzX4jRSXvpGjR+yla/F6wLLWhvxvhi3sB8C0A9LIPU7Qk4LhFOBf/
thyW/ya2/JEioLioI/3kmD/S0898kEfWee4a0gwOpm6NDlRvHdDC/JIchSau
nXgplbydoslDD6apQw6iqcNS+O8Re9u0oSmajs/Th6eIP7OI/dVjlM/8+5xX
U7Tw3YPpnt9eQIf/9DaqWesWGjbscwPznFqo1bsDGYCa9s8XHWiG9zf3uE6Z
AO1y5VWUK5jzTb//wZfUqOHvqd4511H9c8PkV/jdK8H718O5zq/fg86pez39
71F/pp/V/A1ddXU/Kt2wqerBPE7IV2UDOiJSJlChMw1pq+z7i3u9CraNnMBz
TXwGrlLMc1Bmuy7itkHc/SpYvnyBdNxy+GB+YYMGWEV5Zk4BOHfeSnp56Dga
MmwcDR8x3pJXbFE/8zbvb0Hf5XlGfAVr/At6992JyUMT4ypJtvYLUraKKGEm
x8Y5pjrDXK2fOHUVqB+eaCQ1BUO2dCoX58mFnsZKR1DBwazQDImItrVg3jMd
mvh/RxxBhx9+eE5hHnekKfj9ctJJMugAcQBlYE4lugVbSeBZVeGSCz2No3NJ
6la3b2Vco6JlzOLxBuZOZbpn5NWUnb64YFtJBisxuerCD992CQEnVpgX0Cir
wbyP2eL8yRJ8OQOfB7q6sqix8NbKRDsSREk9EHTPTjIv3z15Vr6qcdFZub/k
7SPg6wGw+97tSCdXLL0394qnnYLaPqw+RDnU8tvx+17LPLQc+uiVqqmnnrrQ
9o/otBXR/cy9SM+lC2HtmEXAVqZBehlb5tcbyzydv8PpeJqESioolQRcTg4I
uzP6/aGaFZu8SCHM4sk0wVdUGX0LjxSwhFk3Psvcs4rTuZeAJGDquT315F5Z
q0uH4F1tGLLwRee6cMrmXXQlB9WAFAyawUAuPNK3ccLzuMoaVJ/qk1YG9ZDv
eirqOGb/iNTtmLrnJL9TFiQVgBVvYG532OLQJPaeVaDehg9yQSTdroOHY7Xo
V2Nq3wwUCrS0pRmYKtRlIdrWjfdevPvYmRMHj4mRE15XfwGrTcX9ec+pGRhc
K26D2kd5GgpfJah525KaeMyb712Bg/stSjHO4wFU7OO9A29Ym3n1qqL6m009
1bmukvabqP29+hLaPzJwU+aJJW9gHgpzjwUYpTS57CS+VLoBShdVRkXxrMgK
r2Uecc8u+GjyxwSCVClvWD3pctIEWk0J2yfo3kPz4Hge95OWXQcSFWBR9Rl0
vAsgCeshn/TUwDxr85MG5nancNKkutwsAYmzknaGuI+RqsWjACY6wZcGlKHQ
kRaj/Wjvsnwj7jnInSIsw/RcgOs9izqfeaL7C3IvBCU2C7kHJx+7dGsEJU0L
GHwirH53rhXPYKce6xt0Y5TDlylQQrwK62mYm8Ub8eLN2+97QghIQFdtLPMi
uvb6XiaaxftCX91LX8UjcNgjWphVqj4GO3CTE0GaTh84gahP8BU0ARpvEtBd
Dm2yMK3FH1AW173itWlamCdLYJaofdB5XfcgE5F5tqcz1kXUqTN5qZlfcLV5
zLbRWeaOESHrJeglGPqJ4NA2i+tmcVx67gnxdN3nQE9dBoz3ugHtGLufBehe
obpZWhqYZ+0xpzJnrs21qq5v07Sdabtc6MBlBuZGsXKhWOacRq+MDlSuDjQH
zH/V07hZjHWeJzPyBgCVCwBT34VT3xbMbzA+c6PUhaPUpi1NW1ZHHWhRVETX
qTA/5dRTzXL+KCs1MFQu+52ooomZsvY2k6T3HBQiGVW3Ffk9pIxR9aB7u5M1
4a2ZRKtIGTM9NujekraL7vrZOEem95Wvx1XBOvHB/Nx69QzMoxQs2x0rNI7a
jiDIEI5REIttwSRV7gzLG7s8CaEUvx48YX7Zbuso3Qr6PUk5Krutkl4v0zoI
Oy7bZcj2+XJxz55ztihqRdf1UtwsAuY//rHxIeeD4ugUKqmSITY37vsiQ0Ga
9Lp5BnN+D2W8eogJ80ronK72SALzpGVL2rbe81f0+KTlTTiQZ2Qg5MM9JawX
LcyPr1mzGsI8aSInTSIsD8CiEwFxLHFQwq1sJWaSKxj1ibuiE09pYuvVOHJ1
9aRru3pcQNIwV/Ip94t70x0wC+2SqFPoYR6UVI3j+LV16Lqm/h7cL5j2PIGF
xYbr6lm9XmI91K2fiFvvGv11lU8fL+91a/kGWvseMupD4jWNMiZebU9lpaxO
h8U1FV31rgfJ87zzFsxvTE+AsmXOfvOMRrNEnSb7/uWKlFm/AtRTRrWT6BJh
BfyeTqgVkEwpjtXls3TjJGZSsgY6Kx9t+Ii3kcdIPOVbdReQFMm7OlE9LjBp
mApwXfKsiiWWSq+cTaJrGpgHJasSnVtXh3GSY2WQXEpcLxvJpALO4ehhBvXu
gC6BXnoHLO+ApKt3cf+ahGauPqTsY79/V81q6q1DR08E4O1zO+fT6WUSfaq8
fQ3MbQWqcKItNceJF84eyPuSKQUlklLP44W51zqTia5KNMqjK4+y9N71sumw
smey+jXo2nEeY8P2CXwKYOCpg5gmf0yo0RHhZtEOqtbKxfSK0pA8NEEA851X
uQe13oPaJ8Qy960CTtrGGsgGJjaLq5dxny50Tyjq6uiABG9s+TPAx/S2E7Wx
8QKwizaKun++plo+YfhUHpQzvVaLotZ0/Q3GMvcvOReNl2ECo1CYx0hOpevw
WpjHBFUMAOiTbilJpuLCJsw9IDtJ3DfsBMI8Ybsk6ohJYZ7u5E4d6sAa5WeO
W78x2tKVkjkow2PY9orUu4BglF4GtF9YvbkMohh9SIB7MPWWT0/4P2ZwsTVv
Ehvm/lxDmYK2Mo6zYH6TcbMkTrSlSxQV1SG9j8hS8YM6T5hlHnSuoMmhoPL6
Ek95OlqGbhbx6KrJ9BiYNMw7cIr7SJhgywOSrLlZosDnq8MKuFkik0tlI5lU
wDkcfcug3l1uFk+ecB/cAxKDxYF57D5k+fzl05J7oI3h4vL2vcgB6sBb7gbm
jgIlTGCkS4QVCXNp7XuTKYUk3PLm0XaBPypBlPqojnhpWWYFTtrJO9vP6Iqz
9im3PymS69FUxmeHPk4HTAy6gJaFdvFNRoZZjskt86xMgAa0iRPnHlj/GSaT
UttFbStfEjirnUMTz6mJyJwn2vCEYdrEYLFgHrcPaeYFVHeJ6/5t15zOeLLL
ZJU3KPnZgQc5W/4tW8Eyv9FY5lXCJ5bxo1rgY3MMJazIsYncGzHKYs5X2Hpq
2rdC7duyVRvqaWBe4CCpCJArcqzpnBXqnBkP3qbeq2W9t2xtYF4tG96AosAH
cAP0atevDcyN0lc7pTcDmRnIClEHDMwNzHMD8yy7Z3wJx3LRblkos3diz/0a
OeXtSuqCGF3Yoi+W2rNCVp2k9k7Myck9V3y0vVIzz1cxVloKg4roTxb0JBeD
SRHcLL1uUiZAa9WqVS1XgOaicqv1OYMiezLqRJ4Ik4zOEWCNhkQwJG0/JxzT
EyGljW32hV1GLDRSy+lari4XuHhXRXqiXCTgDcyTGS86Pc5rmP/anc+8Oi7n
T9pxzf4Rj+rZVPhsnits8U6FruNZZh61SEhdQBVnXydcM+A6DHhpidv3MZhX
P8oVwbyIpjfEwDwZzGXbZHHQzxU7itqwZW5g7l6+68rPoCbekZ/tF/s6j8Jq
kiRlnwALUptkyOmA6UdxbZY/V9y2mkciC+UUZQi6xzQYApMk6WLKPZZNdOIk
O+mTNv5fvlA5STvwwpExyOehW3LvSRIV1ga6eg+Li04E6IAcQLrzi3IErICU
22Wdy+XrOI+zrD0K5q77jNbreAmzgpLSJWtHJ3mWF6xOP9T3h+D2R71HJeUS
qTY8ybfi9tVsPkHGOJcW5kcffXRmo1eMC+ZqVKroeQOT96hgd6308yykYKtI
dISECwtU2GkTC3lXEwYkGcpGOV3lj5kwyelYEcmbbEi4fMi6xFE669jXeWUd
hKzk09VHrHN7Vi86ZdTUe4VhHmBlewdFAauArIquQS8o9z3cVLFSKMSoz7A+
HlS/uiRvPl0L6k8B28PaRT2397NvMItIyhXkZonsq5U/ycwwv+Gmm81r45zV
keoorybACnvM0jV4lNJ7V5B6O0Jgx3BPoolVadkqZ6DF41nNF2aBex9Lg+om
ansQKJO2Q9j+XldHUBto4eoZtHXtFQn79FyAY+FKo8AFHQWySSxz4ZcH4KUL
JmkZ4+i1ThfC7luWP2k7yrbyJrSLSroV1f7iqSVGUq445T3AxqyBud0AgY+u
3uX0Ol9nHKV3WVBRKTw1yYBUZY7r9w2Dk+5x2wdz3bL3hEmuoqAddxDLtB2i
OnOcThoEUFc75Nhn7vjE4/vMZa71YizX10/CRrh3IvW6ggmzdG2q9q8o/Q0b
2OLoi2y/OEm54uiJgXnlP47oXDKuRFuR1kOMRD2BDRuQZCgO1OIkGXKdJ2E5
Q461XEgM96AkSRHJmwLvz+Oe0VmPgR0pxv1lA+Yxk5rlNJpFrfdY0SxKvpFI
F43sgzHq06XXMRNmhSWlE+cLc++kDQpX3vEgF51quUc9ebkMrICkXLoBLVZf
rXyutWrTlm78tXGz2OluNe6EMOvBm7jKByJ9SJ02yVBsBdEk14qyGiLLqSbk
UvKBu94ElH6aCEySpD5ye5M3hd2fepx4ibJaBs9Tiu48YfcXBXM1SVRoG8RL
apa1OHOtb1fx50fFmUc9eXkHZdU9FldfcEy8hFmaJG9x2zEsoZ0oc4L+oDMU
NIOJmBT1RAZZLyGx5y5i99XKBboF81uMz7yiE6j64+2JpwP8+JWbe8uRoqod
ydRbDgMRKkk3AwGaI/2pxjrTmmF+s4F5DjuNUdrwwcSd4jbf04xWqYExH8Bm
YF5pbGnd5nK66ebfGMvcdFIz6BgdMDpQlXXAwDwfrBdThkqzXqpyZzVlN4NN
mA60bmssczdI8uWxMF/KYQYaM9AYHagSOtCGYX6LcbOkc1YEQbSy4VrZ1zMd
tkp0WGOdG+s8SAcMzOWioaAQxAMFOQNzA9cDpXvmulVS9wzMbcW1Xl6M+GYb
or6EUApcQ1/gK/bTJBbCdYKTEmleWuyCuf27PeAkSnTlrBwNf8GusfiMxWd0
oGrrwIm1TqI6dc8x0SxOalB7AYsvIZQDV2UhkNjXs+RdbPMssHG9JMC7QMez
AlIsTlDzrXiWTAcu5Q9aSRkzYZaxxqqkNWYAXLUBnM32MzCPcrP4lvOm06YW
Dy7xA0C7sk3JZheVYEu3Es87GOhWTAatSvPuK66fMLOjAb0BvdGBvNcBA/PE
ME9bApa7Q2OZq0upXRZ9jARbLpjzuQMsd/nSAd9g47H8dU8PpmPmfcfMpsVm
zlU9rHcD86Qwd7lRNBnsPPB0kgPFTFBl5ZrQpLV1Bo14ia5EYqywZEQG6Abo
RgcKSgcMzG2Fjkyik2gCVJNYKDQpUdQEqExoZFn2sRJduRJWBSWJyuG7NQ0o
CgoUxrrPf+vewDzb0MmXkEKTsMrANNu6bc6X1zplYJ5tBT1gMDcJq4z1mP/W
o2mj3LWRgXm2YW7Ol9fWi4FJ7mBi6vbA1q2BuYGvga/RAaMDBaADBuYF0IjG
IjqwFpGpf1P/+aADBuYG5sYqMzpgdKAAdMDAvAAaMR+sAlMGY50aHTiwOmBg
bmBurDKjA0YHCkAHDMwLoBGNRXRgLSJT/6b+80EHDMwNzI1VZnTA6EAB6ICB
eQE0Yj5YBaYMxjo1OnBgdcDA3MDcWGVGB4wOFIAOGJgXQCMai+jAWkSm/k39
54MOGJgbmBurzOiA0YEC0AED8wJoxHywCkwZjHVqdODA6oCBuYG5scqMDhgd
KAAdMDAvgEbMZ4vor89MpFpXvmokYR1wveVzu5qyHVgrXFf/BuYG5jmDhgQ5
mb/ENcADoAF6/gEznwcxA3MD85zBnIHEf5vKdlGdn3yf5q7aTHV++gP830Jn
4/88/n8k/q/eQnWPPIRK1mylc44/hObj/xk1D6WFa7dR7RMOpUXry+jME1O0
GP/POjZFS0rLqcZxB9GyjeV0zM8OphWbttNPvv89WrV5Jx35g8Np9Rb8P+Rw
WrNtF9U89Me0Dtc/IfVjWl++i0486MdUiv/HKv/ldv7P+62zj1uzdZc43yqc
j8+/cvMOOuLn36PluN7RuO7SDVY5lpSiXHb5zjwhRQvXWeXm8p9R8xBasDZ9
X3VxfyWrtzr3Le+f64Prpc5Pvy/qi/+4/vIZHqZs+TXYGJgbmOcMGBLmp9gg
Z1ixMMQZ4FJK8JlBzhBnYfgtABAZiosgDHEWhuZSgJwhumzjdgHVFQAsQ5aB
u3rrTmIAs6wFkNeV7QbAdwPelmzYvps2suywZJMt/HkDC36T+/Jx67btFufh
8/EAwcLX4eut2LSDlqMMXA4uDw8wspyL1pWh3CzWPYj7gcj743tloKt1IOrE
rh8e8AzM8wuUVWHgMjA3MM8pzPfu20/fwSKfuxKigtz+zFBjSYOc4SdBnoY4
g3wJoClBzjAVEIc1zpBdwyC3AS4gDtm4Yy9t3rmXtuzaR9t276OyPdb/bbv3
0rY9e/F9L5VjWxn/Jrbvo63Yl4WP4eM37NgjgC6FBwwL6DstoGNAkUDngYbL
6Ya6AnRlwEoDnaFug92GOdcT15uxzA3QkwwiBuYG5jmF+U6A85r6Z9GICYuF
vDpxCb369RJ67eulQt6YBJm8lN6aupzegbw7fQW9B/lgxioaOXMVjZq5hj6e
Y8mn362jz+atoy/nl9JXCzfQhMUb6eulm2nKsi00bcVWmrGqjGauKRcyt3Qn
Ld6yi1aVAcblgDKgvhHC/zfs3OPIpl3YDuHtpZC127H/9r20YutuWrhplzjP
zDVl9A3OzTIV15m8fIu4Ll9/3MJS+mL+elEuLt/Hc9bS6NlrhHD5P8R9fDBj
pbind6atEPfJ8ubkZeK+X0cdsLyGOhF1M3Ex9TjvLOJ6MzA3MDcwN4DOGaCT
KBfDaBvcF0PGLaShLF8touHjF9NwG+wW3AEyAP11wO3NKcvo7WkW0N8HAD/8
FjCf5Yb553PXC5iPA8zHL94koDp1+VaavnIbfQuIz1q7neauB8g3wz0CiG/c
uY82jX+e6tfvZsvd9PJSWOF7YY2zLB9JvW4cSQvYQods3r2aXr4B+/b6kCZt
3k0lG3fSrHXbaQbOzcLXmYLrTVq6BdcHzBdtBMxLAfP19OlcC+ZcZpaRKD+D
/N3pKwHy5fQ2Qxz3+Abu9XWA/FVA/BUAnIXrgutm2PhFop643gzMDcyT9Ddj
mRvw5wz8DKMN23ZS5wvOoJfGLhQyZOwiGvIVwA5wsTDYGWavOkBn6K2gd79Z
aVvnAONsABLyCWD5WUkpfblgAyzzjTRxySaaBKt86opt9M1qWOUA+ez122k+
ALxy2x7aBJCXTRgEiD9Pn7MbBbAuZ3jXv5teWbGfdsGVsWflSLoRMF++fz/t
xvcv+wLkfb+Bdb6PlmzZS/M37cY5d4hzs/B1+HqTcd0JuP5XDPMFpTQG5WKY
jwbMPwLIWT6cuZrex328A5gLa3zKcjFovToJwgCHDBMAt+piyLhF9DIGva4X
1hb1ZmBuYG5gbgCdM0AnUS6G0Wr4lAd/MZ/++8UC+u+XC+hFAP1lQGsIrE8W
BhlD7RV2NbDrAcB7C+4Its6Fq2XWahrF1i7kU1jlDPOxDPPFm2kigDoZVvI0
WMtsNc9at4PmCKscPnPAePueNfTajXfTiOX7YXXvp/K9FsB3TwLg+8+wwgVX
fQSYf0Sr+OMbd1N920pfh4FgWdleWrhlD323wbLOpYU+bRVgjutOXLZZlIMH
l89LNojBZvScdQ7MP/gWMMc9vIN7YZjzvTHMX/l6mbjn4XCpDPlKCkCOge7F
sVY9cb0ZmBuYJ+lvxjI34M8Z+BlGSxCFcnPbuvTCZ/MBdYAKwkB/CUBnGQqY
DWO3C7sc4Hp4YzIsWFjm78CifQ9uig/hM1dhztD8csFGWMTsYtlCU+DDnr6q
nL4VVvkO+q50Fy3balnle1YA1PUH0VhAfPMeoq17iXYC5ntXWtsnqTBnwGPb
ePwOftPqHftpESzzBfgydyNb5zuF8HWmw4c+ZUUZfY3B5Cu4esbiKeHz+Rto
DFwtDPNR8JezMMzfA8zfhmX+pg3zV3GPPHANt61yHthYXmKQf7mQ/gOQ//b8
M0S9GZgbmBuYG0DnDNBJlIthxOF3z48poUGQFz4H0D9ny3MhvQiAsbBlOpT9
xfCdvwL3w+uwXt+EZc4wZ6t2JPufMbHI8um8UgHNsQs3YfJxM1wsW2kKrPLp
q7fTt7DKZ5fuoLkbdtPKMisaZR9DG1b3AsAcPKZNgPkOdq3QDOqvwtzxp3ej
viA8Q3/Nzv20eNs+wHwvzYOrhQcJlpm4zgwAferKMpoE63wCfPbjMLBwubh8
H8M6/wguIRZ2s1gwXyVg/joGKnax8MA1dMIS4VqRg5qwyL9YKJ5ieODjejMw
NzBP0t+MZW7AnzPwM4zGIsrjd63Ppuc+LaHnAKnnhYU+HxYoW6HsR4dlKqxz
uB3gNxeuFoCPrVm2zEfOYhcLYA5hWH7Gljlg/tUSwBxRJSrM52xA9AmovXzb
XtoEmEvLfBzgDCbT1v1smRPtZdeKC+Z30xvsZ2HrHPCfj33X7dpPy8r308Kt
+6gEZj2fm2UmrPNvGOaIbJmEp4IJeDoYt2gz/OYb4TffQKMx6IxEWVk+wFMF
w/wt3Au7WPjeRgDmwyYspSEAOVvk//3SEq6LFzDQPf9ZCf2hTV0aW7LOwNz0
zUR908DcKEwihUliKTDMX/l6Of3jjen0r9dn0D1vfkv3vz2THnhnJj383mwh
/T6YQ4+M/I4eHz2PBn5SQk9/toCehYX6wrgl9CKgN/TrFfTK1JVC3vhmNb09
E5D8rpRGzYOPesFm+nwxXB3LttHEVdtpypqdNH39LpoH+K7eDh85fOavwmc+
fLllbcNgJxjcgT5zorX0yo3dqNdra6kUrpZl5UTzMAJ8C2t/+tpdQiav3kHj
V5TTl0u20RhA/OP5G2kkyvPerPX01rfw0cMKHz5lhZCXce8vjl9KL4xdLO7p
mc8W0pO4R77XR0fNpf4ffkd9UAcsD72HekHd3Pv2t3TPGzNgwS83MDd9M1Hf
NDA3CpNIYZLCfDBAdnv3UwHxGXQ/IP7Qu7Ooz/uA+IdzhDwGqD0BuA34dL4F
8s8X0SCA/L+A4FDA8JUpq+iN6auFvA1Yvjcbboy5pfQJIDpm0RYauxTWMfzX
k9Zsp2lrd9KM9bthne+l5SD3RljXVjTLIPocMIfXhMrhehHRLLDE4XmhPfYE
KHhPuwH67fCz98TvL2HDsu1E8wHzWRv20DfrdguZimt8vbIcA0gZfbFkC326
cDONhkX+4ZxSehdPEW/NWE2vTVslZPjkFTQEk53//WopDUI9PPfFInp6zAIa
iHt94uN59DgDHQMZS98PAfV3Z9ODqKM/NT+dBo9bbGBu+maivmlgbhQmkcIk
hTlDjK1NtsgffHcmrNBZsMZn0aMj5whhmA8AzJ8G4J5lNwOAxyB7CT704bBO
X52GyUMAkuUdwHLk7FIaPXcjYA4/NWA6Dn7zifBfTwXMp6/DBGXpbpqzcQ8t
KttPa3aQ5SsXQE/HmQ8HyGF0E1hNOwDzXuxXx2ccQvCq0NzXENWCAeADhvm2
/TR70x5xXpZp8JlPxlMADyA8kHwGf/knJWydb6D3Z6+nd2auFU8QLK/iaWIY
7uElPGEMxgA1CC6lZzEB/PSY+fTkx7DQR8FC/+g7If0B874fsIU+SwB9kIF5
zvQyiQ5XpX0NzA3Mc9Zp2M3yAsIPb21+Gj0MQFkgh1sF7oVHR84VMmB0CT0F
18O/4YJ4Hr5jht6L45cIi/YVWLavw8J9e8YaIWyVfwiXxmjAky3iLwHz8bCQ
J8FSngJyf4MJym8BcpZ5oPJSwHgNclbBSyImP7cA1JtZAO6tkG0McPv/Fk4I
ht82sGDftThmxU6iBSD8nM17aSZOwvINYD4FA8fXGEDYvfMl3DyfLtgEt89G
WOfr4W6BdQ6Qs7yOgWgEJj2HwE/O7pb/jAXQcY98r0+xhS6APlfIYxjYHsGT
Sl88tdxVdLqoNzMBaiZAkwwmBuYG5jmF+UtYpv7IyNkCVk/AAh0IK5zhzZY4
yzNwrTz3OaI4vlxML34FiE9YBot8Bb0G98pbcK28OwNRIRwZwguHECnyKVZb
fo7Jxi8RzcIwZahOZZCzVY7JyTlwibCUAMBLQOoVNtDZB85A3wjrWwjDGyIg
DuFtDPFSnvwEyHkQWI5jF7HfHOeS5+VrTIerZQp855MQSTMOES1fIDzxM7h9
PkEMPEfdfACgs7yDsr81DW4X3Avf05CJy+FyWULsehoEH/pzeBL5N6x0lqcx
Qfwku5tGw+2Eenp50hIDc9M3E/VNA3OjMIkUJomlwJbl8KnL6PpWdeiZT+fR
vwEsjmYZBIi9wJOckBfhTngZlvjwiVakx2uI+niD85hgGfz7iNO2Vn6uFzIG
4X+fY9JzHKzhCXCvTIarYzpcHt/CUp6JHCpzNu4CxLEEH7IAM56LYVWz33sF
3C0rAec1gPRaQL2UwW1DnEHOn9dj21qAfDV+5335GAvm++E3R3giJlVZ5iBf
CwN9BvvoV27H4qEylMWKN/8cUTafoowfo6wsH+FJgu/hHUS0vIl7eh3x86/A
Uud7HYp7fgn3PpifRiAcyTKI5wwA9t8hmmXEtGUG5qZvJuqbBuZGYRIpTFKY
j0BOkhFTllCXC2pjsdAiKq53loix7tSohogtv7ZxDZGrpHvDY8QS/manHUkf
YbVnqzonwNpdTxfU/hmNRxhi/aO+TxOXb6aLkPd82ppt9AvkDZ+5YTudhPzi
3yFF7dnIQ16CTIlnHPy/tACpbM88/P9oMZJVHfW/h9HSvXvp6MMOo+X79tIR
/3MYrSD8/5Hn/w+t34/B78uwfw3svwTHn4XjFyIxlzxvXeRBn4ssiqf84Mc0
C1kTf3Hs9xCqWEYNjj8UvvSt1OiYnyNschPVO+rnCKHcSG3PORED0Vq6/OSa
Iu686Bc/FflnujU5AjlpltE1jY9G3PkyugL1MRRWe1fUz2sYAF+ZbqJZkuia
2beMDMwNzHMGc/mmofdnYyXnd6tp5DxkE5y/lj5esI4+WQhrG/LZEiTOWool
+ss30viVWAy0ZgtNWotl+uu30bSNyLmyqYxmbEGSK8jMbVjlWb6d5pRjpecO
LBDauZPm7dpJJbthke/ZhfhwyD5LFrDsh4UuhfDdlvn4rxP5u/ivHmufU5wb
1+Br8TX52lwGLsuc7TtoVhmeELYiKZddXi771A1Y+o974XuagIVAX+Eex66A
m2gZnjKWIJ/LIiTognyyEEm65iM+HXU0cu5qYZWbNw0Zn3mSQcrA3MA8ZzBn
RTTvAM3s/acG5AbkSUDO+xqYG5jnFOZJFdLsbyBmdCAzHTAwNzA3MDc6YHSg
AHTAwLwAGtFYMplZMqbeTL0Vkg4YmBuYG6vM6IDRgQLQAQPzAmjEQrIuzL0Y
a9noQGY6YGBuYG6sMqMDRgcKQAcMzAugEY0lk5klY+rN1Fsh6YCBuYG5scqM
DhgdKAAdMDAvgEYsJOvC3Iuxlo0OZKYDp/7iNKpT9xxKpVIsKTqp8YV0xE9+
QvXqn2fE1IHRAaMDRgeqiA6cWedsatCl2II5j4j84ZQmDejkSy4SYK/V6AI6
8eLzqWaD8+hnF9aj4y48l4654Bw6+sK6VANyFEuDc6hGw3p01MWQRvWpxiW/
pBpNzqcal14AuZCObmbLZfjvkovw3SsNsE2R5vjdKy3we/O0HIPPLsHvxyhy
UuciOu2aDhopxra0nN6jmE4ovoyOLbrYkpYNQ4R/98txRY3IK8diW6i0wu8h
clxrnDNCjm2FskCOw3kqU+R1E/2X9Rv2P7Tuw9qlIdo+RLy6EvHdpYuqXvLn
ZtBNrSg6b+s+69Jx0JcgCdU13M+xUdIc+0RKA+yjSNQ5K/A79z/u9xYDIqQZ
foccLeRCOgaMOAZcYDkW9fzzokvo+DZN/NK2Cfoa9B7XckSrN7yPLdwGOEaI
aI9G9LPWOH+7ZpBLXVKzfTP6Oa7BffO4NpfQiR1bWHJFS5fU6lREPuncimrZ
clKXVpSW1vjslpO7tiEhvB2sOgnnP74tytLqEvp5y8Z0PMpYE3JCi0ZUq3kj
OrlFYzq1ZRM6rWVTqt2qGdVp05zObtuC6l7eUvBbcFw+3thmujTXzX/rscWI
qQOjA0YH8loHJMP/H+D0Dv5pAEiYAAAAAElFTkSuQmCC

--20422718-30230-1157028687-704
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

--20422718-30230-1157028687-704--

Re: v08.02.0100 uploaded

=20

> -----Original Message-----
> From: Stijn Vanroye [mailto:s.vanroye@easytowork.nl]=20
> Sent: 31 August 2006 13:51
> To: Dave Page; pgsql-odbc@postgresql.org
> Subject: RE: [ODBC] v08.02.0100 uploaded
>=20
> Any Idea what I missed when uninstalling the dev. Snapshot on=20
> my day2day machine?
>=20
> I'm sorry I might have spooked you with this. Maybe an=20
> uninstaller is a good option for future releases?

That's the problem - it will uninstall itself, you just didn't :-)

In Add/Remove programs you should see a 'Remove' button, or just
right-click the MSI file and select the uninstall option.

Best bet is probably to grab the old MSI again, reinstall it, then
uninstall it properly.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: v08.02.0100 uploaded

> > Any Idea what I missed when uninstalling the dev. Snapshot on my=20
> > day2day machine?
> >=20
> > I'm sorry I might have spooked you with this. Maybe an=20
> uninstaller is=20
> > a good option for future releases?
>=20
> That's the problem - it will uninstall itself, you just didn't :-)
>=20
> In Add/Remove programs you should see a 'Remove' button, or=20
> just right-click the MSI file and select the uninstall option.

Oops, I read somewhere you had to remove the registry entry's and remove th=
e binaries. While trying to do 3 things at once I kinda jumped to conclusio=
ns on this in stead of taking a better look. I feel a bit silly now ;-)
=20
> Best bet is probably to grab the old MSI again, reinstall it,=20
> then uninstall it properly.

That indeed seems to do the trick. Everything is working fine now, I tested=
the new driver in my BLOB test app without any problems.
Thanks for the help. And congrats on a job well done in the development of =
the ODBC driver (this goes for the other developpers too).
=20
Regards, Stijn.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: v08.02.0100 uploaded

Dave Page wrote:

> Best bet is probably to grab the old MSI again, reinstall it, then
> uninstall it properly.

I agree from my experience over the last few days that multiple
installs/uninstalls seem to be benign. That's one reason why I went back all the
way to testing with a v7 driver and server.

The only thing I did notice is that removing any DSNs appeared to rely on still
having the appropriate driver installed, I don't know what would happen if one
tried to edit a DSN with a driver more recent than the one that installed it but
I'm doing everything I can to play safe at present.

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: v08.02.0100 uploaded

=20

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org=20
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Mark=20
> Morgan Lloyd
> Sent: 31 August 2006 17:17
> To: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] v08.02.0100 uploaded
>=20
> Dave Page wrote:
>=20
> > Best bet is probably to grab the old MSI again, reinstall it, then
> > uninstall it properly.
>=20
> I agree from my experience over the last few days that multiple
> installs/uninstalls seem to be benign. That's one reason why=20
> I went back all the
> way to testing with a v7 driver and server.
>=20
> The only thing I did notice is that removing any DSNs=20
> appeared to rely on still
> having the appropriate driver installed, I don't know what=20
> would happen if one
> tried to edit a DSN with a driver more recent than the one=20
> that installed it but
> I'm doing everything I can to play safe at present.

It'll ignore any settings it doesn't know about and default any new ones
not in the DSN. It's quite safe as we're careful not to reuse old
parameter names for new/different purposes.

BTW Mark; the testing I suggested yesterday should be done with this new
version of the driver. I would have mentioned that last night but I
didn't realise Hiroshi would commit his last changes so quickly.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: v08.02.0100 uploaded

Mark Morgan Lloyd schrieb:

> The only thing I did notice is that removing any DSNs appeared to rely on still
> having the appropriate driver installed, I don't know what would happen if one
> tried to edit a DSN with a driver more recent than the one that installed it but
> I'm doing everything I can to play safe at present.

You cant edit or erase a DSN in the DSN manager after the driver is
removed. You can create new DSNs with the same name though. At least on
Win2K one can overwrite existing but broken DSNs. You can overwrite DSNs
for other DBMS.

This affects only DSNs where there is no driver anymore.
AFAIK this doesn't happen just by upgrades.

I think I had this issue when I moved from 7.x to 8.x drivers that where
in another directory, too. Wasn't there also a namechange PostgreSQL
to "PostgreSQL ANSI" and "PostgreSQL Unicode"?




---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

ODBC v08.02.0100

Hi all,

I make some tests with this new version and i notice a diference in the
behaviour about the structures of tables returned by queries trough this
version and older versions of odbc

I'm using Visual FoxPro with postgres 8.1.4.

In previous version all fields are marked to accept null values.
In this version (8.02.0100) some fields now don't accept null values, seemed
to me that now use the same definition of source table structure, like this:

CREATE TABLE test (
id serial NOT NULL,
fk_test2 int4,
field1 char(3) NOT NULL,
field2 varchar(10),
field3 date );

CREATE TABLE test2 (
id serial NOT NULL,
field4 char(3) NOT NULL,
field5 char(3) );

SELECT test.*
, test2.id as id2
, test2.field4
, test2.field5
from test LEFT OUTER JOIN test2 on test.fk_test2 = test2.id;

The fields of resultset will be now this:

id int4 NOT NULL
fk_test2 int4
field1 char(3) NOT NULL
field2 varchar(10)
field3 date
id2 int4 NOT NULL
field4 char(3) NOT NULL
field5 char(3)

with odbc version 8.01.0200 all fields accept null values.

I'm not sure about what is the correct behaviour, but this can be considered
as a bug in the new version ?

Thanks in Advance

Luiz

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: ODBC v08.02.0100

--0__=0ABBFB48DFFADD0B8f9e8a93df938690918c0ABBFB48DFFADD0B
Content-type: multipart/alternative;
Boundary="1__=0ABBFB48DFFADD0B8f9e8a93df938690918c0ABBFB48DF FADD0B"

--1__=0ABBFB48DFFADD0B8f9e8a93df938690918c0ABBFB48DFFADD0B
Content-type: text/plain; charset="us-ascii"
Content-transfer-encoding: quoted-printable


So your issue is that now the field types including NULL constraints match
the underlying tables?
Is the change caused just from changing pgODBC driver versions, while the
database version stayed the same.?
Isn't this the result we would expect if we were using psql at the command
line?
I don't mean to be rude, but does your application expect a resultset where
certain field never have a NULL value, but where the database design has
the fields specified as nullable (no specification of NOT NULL)? For
instance in your example fk_test2 is designed to allow NULL, but perhaps an
application does not anticipate the possibility that NULL may be its value.

Perhaps the old behavior was a bug.


Greg Campbell ENG-ASE/Michelin US5
Lexington, South Carolina
803-951-5561, x75561
Fax: 803-951-5531
greg.campbell@us.michelin.com



=
=20
"luiz" =
=20
=20
br> To=
=20
Sent by: pgsql-odbc@postgresql.org =
=20
pgsql-odbc-owner@ cc=
=20
postgresql.org =
=20
Subject=
=20
[ODBC] ODBC v08.02.0100 =
=20
08/31/2006 14:14 =
=20
=
=20
=
=20
=
=20
=
=20
=
=20




Hi all,

I make some tests with this new version and i notice a diference in the
behaviour about the structures of tables returned by queries trough this
version and older versions of odbc

I'm using Visual FoxPro with postgres 8.1.4.

In previous version all fields are marked to accept null values.
In this version (8.02.0100) some fields now don't accept null values,
seemed
to me that now use the same definition of source table structure, like
this:

CREATE TABLE test (
id serial NOT NULL,
fk_test2 int4,
field1 char(3) NOT NULL,
field2 varchar(10),
field3 date );

CREATE TABLE test2 (
id serial NOT NULL,
field4 char(3) NOT NULL,
field5 char(3) );

SELECT test.*
, test2.id as id2
, test2.field4
, test2.field5
from test LEFT OUTER JOIN test2 on test.fk_test2 =3D test2.id;

The fields of resultset will be now this:

id int4 NOT NULL
fk_test2 int4
field1 char(3) NOT NULL
field2 varchar(10)
field3 date
id2 int4 NOT NULL
field4 char(3) NOT NULL
field5 char(3)

with odbc version 8.01.0200 all fields accept null values.

I'm not sure about what is the correct behaviour, but this can be
considered
as a bug in the new version ?

Thanks in Advance

Luiz

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

--1__=0ABBFB48DFFADD0B8f9e8a93df938690918c0ABBFB48DFFADD0B
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable

So your issue is that now the field types including NULL constraints mat=
ch the underlying tables?

Is the change caused just from changing pgODBC driver versions, while the d=
atabase version stayed the same.?

Isn't this the result we would expect if we were using psql at the command =
line?

I don't mean to be rude, but does your application expect a resultset where=
certain field never have a NULL value, but where the database design has =
the fields specified as nullable (no specification of NOT NULL)? For instan=
ce in your example fk_test2 is designed to allow NULL, but perhaps an appli=
cation does not anticipate the possibility that NULL may be its value.



Perhaps the old behavior was a bug.





Greg Campbell ENG-ASE/Michelin US5

Lexington, South Carolina

803-951-5561, x75561

Fax: 803-951-5531

greg.campbell@us.michelin.com



6" height=3D"16" alt=3D"Inactive hide details for "luiz" <luiz=
@planit.com.br>">"luiz" <luiz@planit.com.br>

ADD0B8f9e8a93df9@michelin.com); background-repeat: no-repeat; " width=3D"40= %"> "luiz" <luiz@planit.com.br><= /b> Sent by: pgsql-odbc-owner@postgresql.org 08/31/2006 14:14

8f9e8a93df9@michelin.com" border=3D"0" height=3D"1" width=3D"58" alt=3D""><= br> To "> =3D"0" height=3D"1" width=3D"1" alt=3D""> pgsql-odbc@postgresql.org 8f9e8a93df9@michelin.com" border=3D"0" height=3D"1" width=3D"58" alt=3D""><= br> cc "> =3D"0" height=3D"1" width=3D"1" alt=3D""> 8f9e8a93df9@michelin.com" border=3D"0" height=3D"1" width=3D"58" alt=3D""><= br> Subject "100%"> der=3D"0" height=3D"1" width=3D"1" alt=3D""> [ODBC] ODBC v08.02.0100 8f9e8a93df9@michelin.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""> td> helin.com" border=3D"0" height=3D"1" width=3D"1" alt=3D"">

Re: ODBC v08.02.0100

This is a multi-part message in MIME format.

------=OPENWEBMAIL_ATT_0.129931560109497
Content-Type: text/plain;
charset=iso-8859-1

Hi Greg

I'm sorry if I'm not can express clearly what I need to explain.
My english is litle.

In a left outer join like below, field4 may have null values when test.fk_test2 is null,
now the result is a char(3) empty field, then I presume that this is a incorrect resultset

On Thu, 31 Aug 2006 15:26:04 -0400, greg.campbell wrote
> So your issue is that now the field types including NULL constraints match the underlying tables?
> Is the change caused just from changing pgODBC driver versions, while the database version stayed the same.?
> Isn't this the result we would expect if we were using psql at the command line?
> I don't mean to be rude, but does your application expect a resultset where certain field never have a NULL value, but where the database design has the fields specified as nullable (no specification of NOT NULL)? For instance in your example fk_test2 is designed to allow NULL, but perhaps an application does not anticipate the possibility that NULL may be its value.
>
> Perhaps the old behavior was a bug.
>
> Greg Campbell ENG-ASE/Michelin US5
> Lexington, South Carolina
> 803-951-5561, x75561
> Fax: 803-951-5531
> greg.campbell@us.michelin.com
>
> "luiz"
>
>

"luiz"
> Sent by: pgsql-odbc-owner@postgresql.org
> 08/31/2006 14:14

>
> To
> pgsql-odbc@postgresql.org

>
> cc
>

>
> Subject
> [ODBC] ODBC v08.02.0100

> Hi all,
>
> I make some tests with this new version and i notice a diference in the
> behaviour about the structures of tables returned by queries trough  this
> version and older versions of odbc
>
> I'm using Visual FoxPro with postgres 8.1.4.
>
> In previous version all fields are marked to accept null values.
> In this version (8.02.0100) some fields now don't accept null values, seemed
> to me that now use the same definition of source table structure, like this:
>
> CREATE TABLE test (
>  id serial NOT NULL,
>  fk_test2 int4,
>  field1 char(3) NOT NULL,
>  field2 varchar(10),
>  field3 date );
>
> CREATE TABLE test2 (
>  id serial NOT NULL,
>  field4 char(3) NOT NULL,
>  field5 char(3) );
>
> SELECT test.*
>     , test2.id as id2
>     , test2.field4
>     , test2.field5
>  from test LEFT OUTER JOIN test2 on test.fk_test2 = test2.id;
>
> The fields of resultset will be now this:
>
> id int4 NOT NULL
> fk_test2 int4
> field1 char(3) NOT NULL
> field2 varchar(10)
> field3 date
> id2 int4 NOT NULL
> field4 char(3) NOT NULL
> field5 char(3)
>
> with odbc version 8.01.0200 all fields accept null values.
>
> I'm not sure about what is the correct behaviour, but this can be considered
> as a bug in the new version ?
>
> Thanks in Advance
>
> Luiz
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

--
Plan IT Tecnologia Informatica Ltda.



------=OPENWEBMAIL_ATT_0.129931560109497
Content-Type: text/html;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable







Hi Greg



I'm sorry if I'm not can express clearly what I need to explain.=20

My english is litle.



In a left outer join like below, field4 may have null values when tes=
t.fk_test2 is null,=20

now the result is a char(3) empty field, then I presume that this is =
a incorrect resultset





On Thu, 31 Aug 2006 15:26:04 -0400, greg.campbell=
wrote

> So your=20
issue is that now the field types including NULL constraints match the=20
underlying tables?=20

>=20

Is the change caused just from changing pgODBC driver versions, while the=
=20
database version stayed the same.?

>=20

Isn't this the result we would expect if we were using psql at the command =
line?=20


>=20

I don't mean to be rude, but does your application expect a resultset where=
=20
certain field never have a NULL value, but where the database design has t=
he=20
fields specified as nullable (no specification of NOT NULL)? For instance i=
n=20
your example fk_test2 is designed to allow NULL, but perhaps an application=
does=20
not anticipate the possibility that NULL may be its value.

>=20

>=20

Perhaps the old behavior was a bug.

>=20

>=20

Greg Campbell ENG-ASE/Michelin US5

>=20

Lexington, South Carolina

>=20

803-951-5561, x75561

>=20

Fax: 803-951-5531

>=20

greg.campbell@us.michelin.com

>=20

>=20

"luiz" <luiz@planit.com.br>

>=20

>=20

Re: ODBC v08.02.0100

--0__=0ABBFB48DFE1745D8f9e8a93df938690918c0ABBFB48DFE1745D
Content-type: multipart/alternative;
Boundary="1__=0ABBFB48DFE1745D8f9e8a93df938690918c0ABBFB48DF E1745D"

--1__=0ABBFB48DFE1745D8f9e8a93df938690918c0ABBFB48DFE1745D
Content-type: text/plain; charset=ISO-8859-1
Content-transfer-encoding: quoted-printable



Ahh, I see.

In the LEFT OUTER JOIN, the resultset has potential NULLs, for all fields
from the table on the right side of "LEFT OUTER JOIN".
Per the PostgreSQL documents, in the section on SQL,
the LEFT OUTER JOIN, example: test LEFT OUTER JOIN test2
will first do an inner join to find all matching rows
(test.fk_test2=3Dtest2.id), and then records from the left table (test) but
which have no matching records from the right table (test2), will be
added and the right table (test2) fields will be filled with NULLs.

Back to your example:
The result of your left outer join should be such that
resultset.id and
resultset.field1 --- can never be NULL. This is no surprise.

resultset.fk_test2 and
resultset.field 2 and
resultset.field3 --- can be expected to be NULL sometimes. This is no
surprise.

while
resultset.id2
resultset.field4
resultset.field5
can all also be expected to be NULL potentially, when there is a records in
test but no matching records in test2 (per test.fk_test2=3Dtest2.id).

So I think your issue is that for the resultset it should not have NOT NULL
as a constraint for
resultset. id2 and resultset.field4. Everything from test2 is nullable.
Yes, it sound like you found a bug.


And, you say fk_test2 will actually be NULL sometimes. This will cause the
resultset to always have a row with NULL in id2, field4, and field5
because NULL is never equal to NULL. test.fk_test2 =3D test.id is always
false when fk_test2 is NULL, even if test2.id is NULL.
Futher test2.id probably should not be null, Hopefully it is a primary key.



Greg Campbell ENG-ASE/Michelin US5
Lexington, South Carolina
803-951-5561, x75561
Fax: 803-951-5531
greg.campbell@us.michelin.com



=
=20
"luiz" =
=20
=20
br> To=
=20
Sent by: greg.campbell@us.michelin.com =
=20
pgsql-odbc-owner@ cc=
=20
postgresql.org pgsql-odbc@postgresql.org =
=20
Subject=
=20
Re: [ODBC] ODBC v08.02.0100 =
=20
08/31/2006 16:09 =
=20
=
=20
=
=20
=
=20
=
=20
=
=20




Hi Greg

I'm sorry if I'm not can express clearly what I need to explain.
My english is litle.

In a left outer join like below, field4 may have null values when
test.fk_test2 is null,
now the result is a char(3) empty field, then I presume that this is a
incorrect resultset


On Thu, 31 Aug 2006 15:26:04 -0400, greg.campbell wrote
> So your issue is that now the field types including NULL constraints
match the underlying tables?
> Is the change caused just from changing pgODBC driver versions, while the
database version stayed the same.?
> Isn't this the result we would expect if we were using psql at the
command line?
> I don't mean to be rude, but does your application expect a resultset
where certain field never have a NULL value, but where the database design
has the fields specified as nullable (no specification of NOT NULL)? For
instance in your example fk_test2 is designed to allow NULL, but perhaps an
application does not anticipate the possibility that NULL may be its value.

>
> Perhaps the old behavior was a bug.
>
> Greg Campbell ENG-ASE/Michelin US5
> Lexington, South Carolina
> 803-951-5561, x75561
> Fax: 803-951-5531
> greg.campbell@us.michelin.com
>
> "luiz"
>
>
=
=20
"luiz" =
=20
=20
om.br> =
=20
> Sent by: > =
=20
pgsql-odbc-own > To =
=20
er@postgresql. =
=20
org > =
=20
> 08/31/2006 pgsql-odbc@postgre=
=20
14:14 sql.org =
=20
=
=20
> =
=20
> cc =
=20
=
=20
> =
=20
=
=20
> =
=20
> Subject =
=20
=
=20
> [ODBC] ODBC =
=20
v08.02.0100 =
=20
=
=20
=
=20
=
=20
=
=20
=
=20
=
=20


> Hi all,
>
> I make some tests with this new version and i notice a diference in the
> behaviour about the structures of tables returned by queries trough
this
> version and older versions of odbc
>
> I'm using Visual FoxPro with postgres 8.1.4.
>
> In previous version all fields are marked to accept null values.
> In this version (8.02.0100) some fields now don't accept null values,
seemed
> to me that now use the same definition of source table structure, like
this:
>
> CREATE TABLE test (
> =A0id serial NOT NULL,
> =A0fk_test2 int4,
> =A0field1 char(3) NOT NULL,
> =A0field2 varchar(10),
> =A0field3 date );
>
> CREATE TABLE test2 (
> =A0id serial NOT NULL,
> =A0field4 char(3) NOT NULL,
> =A0field5 char(3) );
>
> SELECT test.*
> =A0 =A0 , test2.id as id2
> =A0 =A0 , test2.field4
> =A0 =A0 , test2.field5
> =A0from test LEFT OUTER JOIN test2 on test.fk_test2 =3D test2.id;
>
> The fields of resultset will be now this:
>
> id int4 NOT NULL
> fk_test2 int4
> field1 char(3) NOT NULL
> field2 varchar(10)
> field3 date
> id2 int4 NOT NULL
> field4 char(3) NOT NULL
> field5 char(3)
>
> with odbc version 8.01.0200 all fields accept null values.
>
> I'm not sure about what is the correct behaviour, but this can be
considered
> as a bug in the new version ?
>
> Thanks in Advance
>
> Luiz
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>


--
Plan IT Tecnologia Informatica Ltda.

--1__=0ABBFB48DFE1745D8f9e8a93df938690918c0ABBFB48DFE1745D
Content-type: text/html; charset=ISO-8859-1
Content-Disposition: inline
Content-transfer-encoding: quoted-printable

Ahh, I see.



In the LEFT OUTER JOIN, the resultset has potential NULLs, for all fields f=
rom the table on the right side of "LEFT OUTER JOIN".

Per the PostgreSQL documents, in the section on SQL,

the LEFT OUTER JOIN, example: test LEFT OUTER JOIN test2

will first do an inner join to find all matching rows (test.fk_test2=3Dtest=
2.id), and then records from the left table (test) but which have no matchi=
ng records from the right table (test2), will be added and the right tab=
le (test2) fields will be filled with NULLs.



Back to your example:

The result of your left outer join should be such that

resultset.id and

resultset.field1 --- can never be NULL. This is no surprise.



resultset.fk_test2 and

resultset.field 2 and

resultset.field3 --- can be expected to be NULL sometimes. This is no sur=
prise.



while

resultset.id2

resultset.field4

resultset.field5

can all also be expected to be NULL potentially, when there is a records in=
test but no matching records in test2 (per test.fk_test2=3Dtest2.id).



So I think your issue is that for the resultset it should not have NOT NULL=
as a constraint for

resultset. id2 and resultset.field4. Everything from test2 is nullable. Yes=
, it sound like you found a bug.





And, you say fk_test2 will actually be NULL sometimes. This will cause the =
resultset to always have a row with NULL in id2, field4, and field5

because NULL is never equal to NULL. test.fk_test2 =3D test.id is always fa=
lse when fk_test2 is NULL, even if test2.id is NULL.

Futher test2.id probably should not be null, Hopefully it is a primary key.=








Greg Campbell ENG-ASE/Michelin US5

Lexington, South Carolina

803-951-5561, x75561

Fax: 803-951-5531

greg.campbell@us.michelin.com



6" height=3D"16" alt=3D"Inactive hide details for "luiz" <luiz=
@planit.com.br>">"luiz" <luiz@planit.com.br>

1745D8f9e8a93df9@michelin.com); background-repeat: no-repeat; " width=3D"40= %"> "luiz" <luiz@planit.com.br><= /b> Sent by: pgsql-odbc-owner@postgresql.org 08/31/2006 16:09

8f9e8a93df9@michelin.com" border=3D"0" height=3D"1" width=3D"58" alt=3D""><= br> To "> =3D"0" height=3D"1" width=3D"1" alt=3D""> greg.campbell@us.michelin.com 8f9e8a93df9@michelin.com" border=3D"0" height=3D"1" width=3D"58" alt=3D""><= br> cc "> =3D"0" height=3D"1" width=3D"1" alt=3D""> pgsql-odbc@postgresql.org 8f9e8a93df9@michelin.com" border=3D"0" height=3D"1" width=3D"58" alt=3D""><= br> Subject "100%"> der=3D"0" height=3D"1" width=3D"1" alt=3D""> Re: [ODBC] ODBC v08.02.0100 8f9e8a93df9@michelin.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""> td> helin.com" border=3D"0" height=3D"1" width=3D"1" alt=3D"">

"luiz" <luiz@planit.com.br> > Sent by: pgsql-odbc-owner@postgresql.org > 08/31/2006 14:14

> > To > pgsql-odbc@postgresql.org > > cc > > > Subject > [ODBC] ODBC v08.02.0100 D8f9e8a93df9@michelin.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td> chelin.com" border=3D"0" height=3D"1" width=3D"1" alt=3D"">

Re: ODBC v08.02.0100

luiz wrote:
> Hi all,
>
> I make some tests with this new version and i notice a diference in the
> behaviour about the structures of tables returned by queries trough this
> version and older versions of odbc
>
> I'm using Visual FoxPro with postgres 8.1.4.
>
> In previous version all fields are marked to accept null values.
>

Yes the driver didn't check the nullabilties at all.

> In this version (8.02.0100) some fields now don't accept null values, seemed
> to me that now use the same definition of source table structure, like this:
>
> CREATE TABLE test (
> id serial NOT NULL,
> fk_test2 int4,
> field1 char(3) NOT NULL,
> field2 varchar(10),
> field3 date );
>
> CREATE TABLE test2 (
> id serial NOT NULL,
> field4 char(3) NOT NULL,
> field5 char(3) );
>
> SELECT test.*
> , test2.id as id2
> , test2.field4
> , test2.field5
> from test LEFT OUTER JOIN test2 on test.fk_test2 = test2.id;
>

Oops outer join. It's not easy to correct it unfortunately.
It's hard for the driver to kow the structure of queries because the
driver doesn't analyze queries fundamentally.

regards,
Hiroshi Inoue


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: v08.02.0100 uploaded

Dave Page wrote:

> BTW Mark; the testing I suggested yesterday should be done with this new
> version of the driver. I would have mentioned that last night but I
> didn't realise Hiroshi would commit his last changes so quickly.

It's OK, I'm used to you guys being on the ball. Yesterday was a bit of a slow
day for me, if I don't respond to a suggestion quickly it's not because I've
lost interest- I've got a fair number of other things on my plate.

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: v08.02.0100 uploaded

This is a multi-part message in MIME format.

------=_NextPart_000_0000_01C6D019.FFA5BED0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi,

Since I installed driver version 08.02.0100, I get this error when trying to configure or delete a PGSQL ODBC connection:

"The Setup routines for the PostgreSQL ODBC driver could not be found. Please reinstall the driver."

And then:

"Component not found in the registry"


Of course, I tried desinstalling and reinstalling the driver, deleting a few things from the registry by hand, and installing the latest friver from Hiroshi Webpage, but without success...

I'm running XP, and never had this kind of problem for the last 3 years...!

What exactly should I delete in the registry to allow a fresh install of the driver?

Thanks!

---------------
Philippe Lang
Attik System


------=_NextPart_000_0000_01C6D019.FFA5BED0
Content-Type: application/x-pkcs7-signature;
name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="smime.p7s"

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIII/zCCAocw
ggHwoAMCAQICEEdYYafa1wkm0CP4DOffAiswDQYJKoZIhvcNAQEEBQAwYjEL MAkGA1UEBhMCWkEx
JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNV BAMTI1RoYXd0ZSBQ
ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA2MDYyMjE3MzE0NloX DTA3MDYyMjE3MzE0
NlowZzENMAsGA1UEBBMETGFuZzERMA8GA1UEKhMIUGhpbGlwcGUxFjAUBgNV BAMTDVBoaWxpcHBl
IExhbmcxKzApBgkqhkiG9w0BCQEWHHBoaWxpcHBlLmxhbmdAYXR0aWtzeXN0 ZW0uY2gwgZ8wDQYJ
KoZIhvcNAQEBBQADgY0AMIGJAoGBAOfvCPREDwfIbzsNRoyBDoSOWfI2NNWd RRMJXuj5ldF22gSQ
6MiXFUjt4HlRIwPb8x13hrv89GW/SmLjFThxf7NKZ8dPTZzp4ZlvrQBRAYhS uTQOJ8azyzruZu54
Ak7fa3pz26Q3B8kg4knZBz3O9Q4K1tK8AEdjNQpyDg/iDdzjAgMBAAGjOTA3 MCcGA1UdEQQgMB6B
HHBoaWxpcHBlLmxhbmdAYXR0aWtzeXN0ZW0uY2gwDAYDVR0TAQH/BAIwADAN BgkqhkiG9w0BAQQF
AAOBgQAAzz+I6MrhWjbfWSgngW/DthHvXiTR6x0cCeb4T5mBb5dgueqgLnrh /2blsbCQuLWh0URe
/1l/QQ2dY2elG3PEDPv9cCl/LcwsCsE1Nj3bGM4gdVx9crYvTw5dyyUuDq1K ShV3uziE+o5Lyfx4
qWRYd6/yIBDVarohdpL8J0DJczCCAy0wggKWoAMCAQICAQAwDQYJKoZIhvcN AQEEBQAwgdExCzAJ
BgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNh cGUgVG93bjEaMBgG
A1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRp b24gU2VydmljZXMg
RGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBD QTErMCkGCSqGSIb3
DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw05NjAxMDEw MDAwMDBaFw0yMDEy
MzEyMzU5NTlaMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBD YXBlMRIwEAYDVQQH
EwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYD VQQLEx9DZXJ0aWZp
Y2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVy c29uYWwgRnJlZW1h
aWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0 ZS5jb20wgZ8wDQYJ
KoZIhvcNAQEBBQADgY0AMIGJAoGBANRp19SwlGRbcelH2AxRtupykbCEXn0t DY97Et+FJXUodDpC
LGMnn5V7S+9+GYcdhuqj3bnOlmQawhRuRKx85o/oTQ9xH0A4pgCjh3j2+ZSG Xq3qwF5269kUo11u
enwMpUtVfwYZKX+emibVars4JAhqmMex2qOYkf152+VaxBy5AgMBAAGjEzAR MA8GA1UdEwEB/wQF
MAMBAf8wDQYJKoZIhvcNAQEEBQADgYEAx+ySfk749ZalZ2IqpPBNEWDQb41g WGGsJrtSNVwIzzD7
qEqWih9iQiOMFw/0umScF6xHKd+dmF7SbGBxXKKs3Hnj524ARx+1DSjoAp3k mv0T9KbZfLH43F8j
JgmRgHPQFBveQ6mDJfLmnC8Vyv6mq4oHdYsM3VGEa+T40c53ooEwggM/MIIC qKADAgECAgENMA0G
CSqGSIb3DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVy biBDYXBlMRIwEAYD
VQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgw JgYDVQQLEx9DZXJ0
aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUg UGVyc29uYWwgRnJl
ZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRo YXd0ZS5jb20wHhcN
MDMwNzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTEl MCMGA1UEChMcVGhh
d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBl cnNvbmFsIEZyZWVt
YWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSm PFVzVftOucqZWh5o
wHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJFXCO3cnw K4Vaqj9xVsuvPAsH
5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHFKlSFD0gEf6e2 0TxhBEAeZBlyYLf7
AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBDBgNVHR8EPDA6MDig NqA0hjJodHRwOi8v
Y3JsLnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxGcmVlbWFpbENBLmNybDAL BgNVHQ8EBAMCAQYw
KQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJlbDItMTM4MA0G CSqGSIb3DQEBBQUA
A4GBAEiM0VCD6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0whuPg2H6otnzYvwPQc UCCTcDz9reFhYsPZ
Ohl+hLGZGwDFGguCdJ4lUJRix9sncVcljd2pnDmOjCBPZV+V2vf3h9bGCE6u 9uo05RAaWzVNd+NW
IXiC3CEZNd4ksdMdRv9dX2VPMYIC+DCCAvQCAQEwdjBiMQswCQYDVQQGEwJa QTElMCMGA1UEChMc
VGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3Rl IFBlcnNvbmFsIEZy
ZWVtYWlsIElzc3VpbmcgQ0ECEEdYYafa1wkm0CP4DOffAiswCQYFKw4DAhoF AKCCAdgwGAYJKoZI
hvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDYwOTA0MTAw MjMwWjAjBgkqhkiG
9w0BCQQxFgQUzuP9/xHcBkuFYfQGx4CaR7Ctt4wwZwYJKoZIhvcNAQkPMVow WDAKBggqhkiG9w0D
BzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYI KoZIhvcNAwICASgw
BwYFKw4DAhowCgYIKoZIhvcNAgUwgYUGCSsGAQQBgjcQBDF4MHYwYjELMAkG A1UEBhMCWkExJTAj
BgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMT I1RoYXd0ZSBQZXJz
b25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhBHWGGn2tcJJtAj+Azn3wIrMIGH BgsqhkiG9w0BCRAC
CzF4oHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0 aW5nIChQdHkpIEx0
ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5n IENBAhBHWGGn2tcJ
JtAj+Azn3wIrMA0GCSqGSIb3DQEBAQUABIGAgGyPYoiLRLWu26WVQFzNmayg gk7GPQe2MppZVltL
+pCy14hdN4Cq9CvG4ujbgCq+2WBXXPFqdsGq3fBQhxtndAml8d6qduftIvqf VY8dQnPuMYH5Eanj
ygLu3sk75DTcbcwf+mpjq//5ZaqPCW7CK11m8umGDodlRxqq9Q64rb8AAAAA AAA=

------=_NextPart_000_0000_01C6D019.FFA5BED0--

Re: v08.02.0100 uploaded

This is a multi-part message in MIME format.

------=_NextPart_000_0005_01C6D01D.C715C700
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Philippe Lang wrote:
> Hi,
>
> Since I installed driver version 08.02.0100, I get this error
> when trying to configure or delete a PGSQL ODBC connection:
>
> "The Setup routines for the PostgreSQL ODBC driver could not
> be found. Please reinstall the driver."
>
> And then:
>
> "Component not found in the registry"
>
>
> Of course, I tried desinstalling and reinstalling the driver,
> deleting a few things from the registry by hand, and
> installing the latest friver from Hiroshi Webpage, but without
> success...
>
> I'm running XP, and never had this kind of problem for the last 3
> years...!
>
> What exactly should I delete in the registry to allow a fresh install
> of the driver?
>
> Thanks!

Hi,

Apparently, the driver name has changed. "Postgresql" has now become "Postgresql Unicode". Changing that in the registry, under "Software/ODBC.*" corrects the problem.

Cheers,

---------------
Philippe Lang
Attik System


------=_NextPart_000_0005_01C6D01D.C715C700
Content-Type: application/x-pkcs7-signature;
name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="smime.p7s"

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIII/zCCAocw
ggHwoAMCAQICEEdYYafa1wkm0CP4DOffAiswDQYJKoZIhvcNAQEEBQAwYjEL MAkGA1UEBhMCWkEx
JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNV BAMTI1RoYXd0ZSBQ
ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA2MDYyMjE3MzE0NloX DTA3MDYyMjE3MzE0
NlowZzENMAsGA1UEBBMETGFuZzERMA8GA1UEKhMIUGhpbGlwcGUxFjAUBgNV BAMTDVBoaWxpcHBl
IExhbmcxKzApBgkqhkiG9w0BCQEWHHBoaWxpcHBlLmxhbmdAYXR0aWtzeXN0 ZW0uY2gwgZ8wDQYJ
KoZIhvcNAQEBBQADgY0AMIGJAoGBAOfvCPREDwfIbzsNRoyBDoSOWfI2NNWd RRMJXuj5ldF22gSQ
6MiXFUjt4HlRIwPb8x13hrv89GW/SmLjFThxf7NKZ8dPTZzp4ZlvrQBRAYhS uTQOJ8azyzruZu54
Ak7fa3pz26Q3B8kg4knZBz3O9Q4K1tK8AEdjNQpyDg/iDdzjAgMBAAGjOTA3 MCcGA1UdEQQgMB6B
HHBoaWxpcHBlLmxhbmdAYXR0aWtzeXN0ZW0uY2gwDAYDVR0TAQH/BAIwADAN BgkqhkiG9w0BAQQF
AAOBgQAAzz+I6MrhWjbfWSgngW/DthHvXiTR6x0cCeb4T5mBb5dgueqgLnrh /2blsbCQuLWh0URe
/1l/QQ2dY2elG3PEDPv9cCl/LcwsCsE1Nj3bGM4gdVx9crYvTw5dyyUuDq1K ShV3uziE+o5Lyfx4
qWRYd6/yIBDVarohdpL8J0DJczCCAy0wggKWoAMCAQICAQAwDQYJKoZIhvcN AQEEBQAwgdExCzAJ
BgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNh cGUgVG93bjEaMBgG
A1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRp b24gU2VydmljZXMg
RGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBD QTErMCkGCSqGSIb3
DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw05NjAxMDEw MDAwMDBaFw0yMDEy
MzEyMzU5NTlaMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBD YXBlMRIwEAYDVQQH
EwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYD VQQLEx9DZXJ0aWZp
Y2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVy c29uYWwgRnJlZW1h
aWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0 ZS5jb20wgZ8wDQYJ
KoZIhvcNAQEBBQADgY0AMIGJAoGBANRp19SwlGRbcelH2AxRtupykbCEXn0t DY97Et+FJXUodDpC
LGMnn5V7S+9+GYcdhuqj3bnOlmQawhRuRKx85o/oTQ9xH0A4pgCjh3j2+ZSG Xq3qwF5269kUo11u
enwMpUtVfwYZKX+emibVars4JAhqmMex2qOYkf152+VaxBy5AgMBAAGjEzAR MA8GA1UdEwEB/wQF
MAMBAf8wDQYJKoZIhvcNAQEEBQADgYEAx+ySfk749ZalZ2IqpPBNEWDQb41g WGGsJrtSNVwIzzD7
qEqWih9iQiOMFw/0umScF6xHKd+dmF7SbGBxXKKs3Hnj524ARx+1DSjoAp3k mv0T9KbZfLH43F8j
JgmRgHPQFBveQ6mDJfLmnC8Vyv6mq4oHdYsM3VGEa+T40c53ooEwggM/MIIC qKADAgECAgENMA0G
CSqGSIb3DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVy biBDYXBlMRIwEAYD
VQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgw JgYDVQQLEx9DZXJ0
aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUg UGVyc29uYWwgRnJl
ZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRo YXd0ZS5jb20wHhcN
MDMwNzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTEl MCMGA1UEChMcVGhh
d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBl cnNvbmFsIEZyZWVt
YWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSm PFVzVftOucqZWh5o
wHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJFXCO3cnw K4Vaqj9xVsuvPAsH
5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHFKlSFD0gEf6e2 0TxhBEAeZBlyYLf7
AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBDBgNVHR8EPDA6MDig NqA0hjJodHRwOi8v
Y3JsLnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxGcmVlbWFpbENBLmNybDAL BgNVHQ8EBAMCAQYw
KQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJlbDItMTM4MA0G CSqGSIb3DQEBBQUA
A4GBAEiM0VCD6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0whuPg2H6otnzYvwPQc UCCTcDz9reFhYsPZ
Ohl+hLGZGwDFGguCdJ4lUJRix9sncVcljd2pnDmOjCBPZV+V2vf3h9bGCE6u 9uo05RAaWzVNd+NW
IXiC3CEZNd4ksdMdRv9dX2VPMYIC+DCCAvQCAQEwdjBiMQswCQYDVQQGEwJa QTElMCMGA1UEChMc
VGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3Rl IFBlcnNvbmFsIEZy
ZWVtYWlsIElzc3VpbmcgQ0ECEEdYYafa1wkm0CP4DOffAiswCQYFKw4DAhoF AKCCAdgwGAYJKoZI
hvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDYwOTA0MTAy OTMzWjAjBgkqhkiG
9w0BCQQxFgQUHV3b9ws+k1uocMeynbtrivCrnPcwZwYJKoZIhvcNAQkPMVow WDAKBggqhkiG9w0D
BzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYI KoZIhvcNAwICASgw
BwYFKw4DAhowCgYIKoZIhvcNAgUwgYUGCSsGAQQBgjcQBDF4MHYwYjELMAkG A1UEBhMCWkExJTAj
BgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMT I1RoYXd0ZSBQZXJz
b25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhBHWGGn2tcJJtAj+Azn3wIrMIGH BgsqhkiG9w0BCRAC
CzF4oHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0 aW5nIChQdHkpIEx0
ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5n IENBAhBHWGGn2tcJ
JtAj+Azn3wIrMA0GCSqGSIb3DQEBAQUABIGArSq1RR7GSzMkVjJlpINd8b5b y0XY0M4YGryrmdO1
chPgFPZxAwjk5HVzNRjgLjryFvddAfDXGfomaLrjKn/MiKRhVauKBxcm9jbt QC8ifPbRu3drfkfE
KTo9QJvCtP6P3rju0laGJ8uY33ALWto91Eh4D7QA8jP0Ud4jfjH+LDMAAAAA AAA=

------=_NextPart_000_0005_01C6D01D.C715C700--

Re: v08.02.0100 uploaded

Dave Page wrote:
> I've uploaded builds of v08.02.0100

The docs directory has vanished from the source tarballs.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: v08.02.0100 uploaded

On 6/9/06 19:29, "Peter Eisentraut" wrote:

> Dave Page wrote:
>> I've uploaded builds of v08.02.0100
>
> The docs directory has vanished from the source tarballs.

Rats - missing \ in the Makefile. Fixed in CVS; thanks.

Regards, Dave.


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: v08.02.0100 uploaded

> 08.02.0100

Dave, is this still the current version? http://pgfoundry.org/projects/psqlodbc/
appears to be delivering 8.02.00.02.

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: v08.02.0100 uploaded

=20

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org=20
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Mark=20
> Morgan Lloyd
> Sent: 20 September 2006 13:17
> To: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] v08.02.0100 uploaded
>=20
> > 08.02.0100
>=20
> Dave, is this still the current version?=20
> http://pgfoundry.org/projects/psqlodbc/
> appears to be delivering 8.02.00.02.

That's under the Development Snapshots section, but yes, it is out of
date so I have removed it.

Thanks, Dave.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: v08.02.0100 uploaded

Dave Page wrote:

> > Dave, is this still the current version?
> > http://pgfoundry.org/projects/psqlodbc/
> > appears to be delivering 8.02.00.02.
>
> That's under the Development Snapshots section, but yes, it is out of
> date so I have removed it.

Yes, but I got there via http://www.postgresql.org/download/ which makes it more
than a little confusing.

OK, I'm heading back to 8.02.0100... I think the thing that was confusing me was
that 0002 was showing a single "PostgreSQL" driver while 0100 has "PostgreSQL
ANSI" and "PostgreSQL Unicode"- I'd forgotten which way the project was leaning
on this.

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq